Friday, February 17, 2012

DAC doen't work with explicit port number

Hello everybody,

After install SQL 2005 I noticed than DAC (Dedicated Admin Connection) is started with dynamic port.

2006-08-08 12:19:47.870 Server Server is listening on [ 'any' <ipv4> 14330].
2006-08-08 12:19:47.880 Server Server is listening on [ 'any' <ipv4> 1433].
2006-08-08 12:19:47.880 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\A ].
2006-08-08 12:19:47.880 Server Server local connection provider is ready to accept connection on [ \\.\pipe\MSSQL$A\sql\query ].
2006-08-08 12:19:47.900 Server Server is listening on [ 'any' <ipv4> 1212].
2006-08-08 12:19:47.900 Server Dedicated admin connection support was established for listening remotely on port 1212.

My question:
Is possible fix port for DAC?
How can I use DAC behind a firewall if I don't know witch port it will use?

Ok, the BOL say: If SQL Server is configured to accept remote administration connections, the DAC must be initiated with an explicit port number:
sqlcmd –Stcp:<server>,<port> (By the way, not is need -A parameter ?)

but it doen't work for me!

Por default connection I have:
C:\sqlcmd -A -SSERVER01\A -Usa -P123456 -dmaster

sys.dm_exec_connections say:
connect_time net_transport client_tcp_port local_tcp_port
-- - --
2006-08-08 12:24:05.750 TCP 3143 1433
2006-08-08 12:49:56.513 TCP 3273 1212

Specifying port I have:
C:\sqlcmd -A -Stcp:SERVER01,1434 -Usa -P123456 -dmaster

but I get "Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired."

PS: I try with any port but always receive timeout !!!

May someone help please..

Thx
Nilton Pinheiro

Hello peoples,

Please....

Is possible fix port for DAC?
How can I use DAC behind a firewall if I don't know witch port it will use?

thx.
Nilton Pinheiro

No comments:

Post a Comment