SQLDBA360 (6/13/2012)
Couldn't the administrator initiate the DAC with a specific port number?Edit: agree with the earlier comments from Koen good question
Good remark. The admin could have specified the non-default port and the connection would have succeeded. The question doesn't specify an explicit statement, so it's up to us to decide how good the admin is in his job 😀
If the question stated this as the statement the admin executed, the question would have been 100% correct as no port is specified:
sqlcmd -S myServer -U sa -P myPassword –A
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP