• Koen Verbeeck (6/13/2012)


    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

    Also need to remember by default that you need to use the DAC on the local machine, remote connections are not enabled