January 11, 2022 at 5:58 am
Hi,
I have a SQL server that has two instances. However remotely it only recognises the first instance but without the name. For example
Servername\instance1 and Servername\instance2 is on the server but it only recognises Servername. When I connect to that remotely I can see that it's the first instance only.
Is there some setting that hasn't been set to identify the instance names remotely.
Kris
January 11, 2022 at 6:40 am
So I take it one of the instances is listening in port 1433 so when you use SERVERNAME it connects.
The other will be on another either static or dynamic port depending how you have configured it. Firstly I would switch this to a static port and ensure the port is open in the firewall.
For named instances to work you need to ensure the SQL Browser service is up and running and the necessary UDP port (1434)is open in the firewall or the program is allowed through.
Or you user the port number when connecting SERVERNAME,54321 for example.
February 8, 2022 at 8:59 am
So I take it one of the instances is listening in port 1433 so when you use SERVERNAME it connects.
The other will be on another either static or dynamic port depending how you have configured it. Firstly I would switch this to a static port and ensure the port is open in the firewall.
For named instances to work you need to ensure the SQL Browser service is up and running and the necessary UDP port (1434)is open in the firewall or the program is allowed through.
Or you user the port number when connecting SERVERNAME,54321 for example.
Thank you so so much. This answer was very very useful to me.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply