• L' Eomot Inversé (6/13/2012)


    I suspect the point he is attempting to make is that a competent administrator will succede, not fail, because if he knows the port numbers he can connect using sqlcmd. Service Broker is just one option for knowing the port numbers, there are others.

    Incidentally, I think the choice of a Service Broker page as the reference for this question is a bad one; when that page says you can't use DAC it actually means that you can't use DAC if you use SB to get the port numbers. A reference to a page about DAC would have been better.

    +1 🙂 and this is why I got it wrong. My initial reaction was... "And why can't I? If I know the ports there are always ways to get in."

    I would have been very seriously concerned if Microsoft didn't support some way into DAC without the SQL Browser Service.



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]