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
