How to connect to SQL server named instance on a static port
-
Hi All,
I have configured sql server 2012 named instance to run on static port 14445. And do i need to open UDP port 1434 on the server or not? SQL browser service is running.
I am able to make successful connection to the named instance when i specify the port number as below
10.xx.100.745\ISH,14445
Do i need to specify the port number for every client connection, is there any alternative way to connect to it without specifying the TCPIP port number?
As now i need to make all the connection string changes to take this into effect. Please suggest.
-
Have you tried connecting to SQL without the ",<portnumber>" yet?
At my workplace, we had an issue way back when where the port number was required until our networking team fixed something... And unfortunately I cannot remember what that something is. (It's been 6 years+).
-
If the SQL browser service is running, I believe you do not need the port number.
-
to connect to 10.xx.100.745\ISH via the SQL Browser you'll need the following ports
TCP 1433, 1434, 14445
UDP 1434
To connect straight to the instance 10.xx.100.745,14445 you only need
TCP 14445
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply