August 14, 2014 at 11:15 am
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.
August 15, 2014 at 12:18 pm
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+).
August 15, 2014 at 3:17 pm
If the SQL browser service is running, I believe you do not need the port number.
August 19, 2014 at 7:54 am
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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply