• If you can't get in with the DAC you may need to restart the service. Do it with the command lines -f and -m to get it to a minimal configuration and single user mode so you can connect up (although, depending on the level of access and control you'll have other others connecting, -m might be dangerous). Documentation is here.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning