January 8, 2016 at 2:28 pm
I need to assign a TCP/IP port to a SQL Server Database Engine (for a named instance).
We have a two node cluster environment, there's a total of 4 instances. 3 named instances have to have their own port. You can find that by going to the SQL Server configuration manager, opening the SQL Server Network Configuration, selecting protocals for one of the instances, then selecting TCP/IP, right clicking and selecting properties. Another windows will pop open for TCP/IP properties, by selecting the IP Addresses, you will see IP1 through IP16, then IPAll.
Looking at the IP1 thru IP16, some have IP Addresses, but others have "::1" or "fe80::5efe...". In short a format that does not resemble an IP address. There's also reference to a loopback adapter 127.0.0.1. Can someone explain this to me? Books online suggests to modify each with the static port, but I would like to understand what I'm changing. My initial inclination, if you don't understand it, don't change it.
Any comments or documentation would be appreciated. Thanks.
January 9, 2016 at 11:41 pm
bobba (1/8/2016)
...have "::1" or "fe80::5efe..."
Those are IP6 addresses, probably better to disable IP6 if it is not being used.
😎
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply