April 30, 2013 at 4:34 pm
Hi All,
What all ports should be opened for a named instance, which is listeneing on 1477.
The named instance name is PDCZV\CZV01
When security opened port number 1477, the developers are able to connect to this named instance using PDCZV,1477 but not PDCZV\CZV01
Can someone please let me know this.
Thank you
April 30, 2013 at 8:50 pm
If you want to allow connections to the named instance using the SERVER\NAME notation, ensure the SQL Server Browser service is enabled and running, and open UDP port 1434.
http://msdn.microsoft.com/en-us/library/ms175043%28v=sql.100%29.aspx
May 1, 2013 at 2:48 am
Sqlism (4/30/2013)
Hi All,What all ports should be opened for a named instance, which is listeneing on 1477.
The named instance name is PDCZV\CZV01
When security opened port number 1477, the developers are able to connect to this named instance using PDCZV,1477 but not PDCZV\CZV01
Can someone please let me know this.
Thank you
You'll need the following ports
TCP
1433
1434
1477
UDP
1434
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2013 at 11:22 am
Thank you Both!
Why do we need to open port TCP 1433 and TCP 1434, while the instance is listening on 1477.
Also is this is mandatory to opem UDP port 1434 always for any named instance with SQL BROWSER running?
May 1, 2013 at 1:41 pm
One more similar Question.
I can connect to SQL Server by RDP to that server but not with my management studio. what i am missing here ?
Thanks!
May 1, 2013 at 2:01 pm
Check windows firewall, also check remote connections are enabled to sql server too.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2013 at 5:47 pm
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply