October 21, 2008 at 5:46 pm
Hi,
We have 4 named failover cluster instances in one node.
1.Where can I check that which TCP/Ip port each instance is using?
2.Is every instance should use different TCO/IP port?
3. If the answer is yes for 2 question what port numbers can I use other than 1433.
4.what happen if all the 4 instances use same TCP/Ip ?
could you plz advice me..
October 21, 2008 at 7:39 pm
1. SQL Server Configuration Manager is the tool.
2. Yes, each MUST use a different port. Ports cannot be shared.
3. Any above 1024 that's not in use by another service. Run netstat -an to see what ports are in use.
4. If all 4 use the same port, the first instance to grab the port will talk on TCP/IP. The others will not be able to do and you will see the errors in the SQL Server logs for the instances that failed.
K. Brian Kelley
@kbriankelley
October 21, 2008 at 10:15 pm
Thank you very much...
The 1st instance will take the defaul port 1433. So when we install 2nd,3rd do we need to give the port number after the installation of each instance or they will take dynamically?
October 21, 2008 at 10:37 pm
If you want the port number of SQL Server remotely then just download "portQry.exe" from Microsoft and just run this command
portqry -n {windowshostnameofsqlserver} 1434
You will get the complete details!
Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
October 22, 2008 at 5:47 am
They will be named instances. Named instances, by default, set their ports dynamically. So they'll do the work for you. Unless you change its port setting using Configuration Manager, when a named port starts up, it'll try to use the port it used last time. If that port is in use, it'll search for a new port (it'll also do this the first time the instance starts up).
If you have need of Kerberos authentication or you're dealing with another situation where the port on that named instance needs to stay the same, you can make the change in Configuration Manager and restart the instance.
K. Brian Kelley
@kbriankelley
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply