• Koen Verbeeck (6/13/2012)


    So it can be different, but there is no indication that it will be?

    So there is a chance DAC will succeed for the default instance as it tries port 1434 first before consulting the SQL Server Browser?

    No, because the SQL Server instance only application that knows what the DAC port is. Because hiding the instance through the browser (or turning the browser off) will result in the client tools not being able to connect to the SQL Server, the DAC port cannot be fetched. Because the DAC port cannot be fetched, it cannot be connected to.

    It's more like a chain reaction. Shutting down the Browser service causes the instance on a non-default port to be non-discoverable and therefore the DAC cannot be used for administrator connections.

    Great line of thought, by the way. In fact, that was what prompted me to write up the QotD in the first place.

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com

    Follow me on
    Twitter: @sqltwins