question

anil_cs avatar image
anil_cs asked

SQL Server network protocols confoguration

Dear DBAs, SQL Server 2014 instance on my laptop is running on default port. I looked at TCP/IP protocol configuration under IP Address tab (See 1st pic), there were many protocols listed there. 1. Looked into IP Address for IP4, it's not the IP Address of my machine but it is somehow related (see 2nd pic). Do you know what is it and when should setting be leveraged ? 2. For most of protocols value of IP Address parameter is a garbage one but for IP10, value seems to be a valid IP Address. I didn't modify anything and want to know where it came from. Appreciate your help. Thank you.alt text![alt text][1] [1]: /storage/temp/3426-port2.png
sql serversql-server-2014ip-address
port.png (211.9 KiB)
port2.png (75.4 KiB)
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
NeerajTripathi avatar image
NeerajTripathi answered
Please refer below links to understand these. https://blogs.msdn.microsoft.com/sqlblog/2009/07/17/how-to-configure-sql-server-to-listen-on-different-ports-on-different-ip-addresses/ https://msdn.microsoft.com/en-us/library/dd981060(v=sql.120).aspx Hope, it will clear your doubts. Thanks, NeerajTripathi
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.