January 22, 2007 at 9:25 am
I have a SS2005 with three instances... what is the difference in ports from the first one listed as 4323 as opposed to 4324... ??? I guess I don't understand. What is the server side command to see what is listening on what ports ?
Server is listening on [ 'any' <ipv4> 4323].
2007-01-22 09:33:57.64 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\INST3 ].
2007-01-22 09:33:57.64 Server Server named pipe provider is ready to accept connection on [ \\.\pipe\MSSQL$INST3\sql\query ].
2007-01-22 09:33:57.64 Server Server is listening on [ 127.0.0.1 <ipv4> 4324].
2007-01-22 09:33:57.64 Server Dedicated admin connection support was established for listening locally on port 4324.
January 22, 2007 at 12:00 pm
First port is used for regular connections where as second one is used exclusively by DAC. I don't know the command in 2005 where as in 2000 you have to read from registry...
DAC is special diagnostic connection for administrators when standard connections to the server are not possible. This diagnostic connection allows an administrator to access SQL Server to execute diagnostic queries and troubleshoot problems even when SQL Server is not responding to standard connection requests. So that sql is assigning different port for DAC.
http://msdn2.microsoft.com/en-us/library/ms189595.aspx
MohammedU
Microsoft SQL Server MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply