Using the Dedicated Admin Connection

The Dedicated Admin Connection (DAC) was added in SQL 2005 as a way to make sure that an administrator could get a connection to a server in situations where it was under severe stress - cpu usage close to a sustained 100% for example.

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

Leo Njampa on 10/15/2009

Had not heard about DAC before! Thanks for showing me this. Much appreciated.

D151BB6B9F on 10/15/2009

Is Admin the name of the account, or is it really SA? Does the account have to be named Admin?

Robert MacLean on 10/15/2009

Short and to the point. Covered everything and quite handy.

WChaster on 10/15/2009

to revet the configure back is the 1 changed to 0 (zero)?

David Leach on 10/15/2009

Could have used a bit more info on what your options are after you connect with the DAC. Still, nice to know that there is such an option. Thanks for the knowledge gain!

Paul Billington on 10/15/2009

Very good. Only one thing, "This ends our discussion.." Are discussion not usually two way?

Mark Sopczak on 10/15/2009

Very good, all of them though too.

vin lawrence on 10/16/2009

never knew it existed

Allen Dunn on 10/16/2009

did not know about this, thanks

Feroz Durani on 10/16/2009

Excellent...

Dennis Allen on 10/19/2009

Very good to know!

thierry on 11/30/2009

or use SQLCMD -A for a DAC connection

Ranjith on 1/22/2010

Good. Expected to see more information on the same

Ravi Raj on 6/27/2010

good one

Steve Hogg on 7/16/2010

Good information, could come in handy. Thanks!

Hank Freeman on 10/1/2010

Video hard to see needs to be larger.

FD928096BE on 10/17/2010

Great Stuff!

Jamir on 9/8/2011

Great video