Who's Using the DAC?

Question

Post reply

Who's Using the DAC?

Steve Jones - SSC Editor

SSC Guru

Points: 736255
More actions
October 2, 2018 at 12:04 am

#77206

Comments posted to this topic are about the item Who's Using the DAC?

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

ildjarn.is.dead Ten Centuries Points: 1164 More actions · Answer 1

ildjarn.is.dead

Ten Centuries

Points: 1164

October 2, 2018 at 3:58 am

#2007645

SSMS won't work, at least not with SSMS 17.9:

Robert Sterbal SSChampion Points: 11050 More actions · Answer 2

Administator should be Adminstrator in:

One of the best additions to the SQL Server feature set was the Dedicated Administator Connection (DAC). Prior to this being a part of the platform, an overloaded instance might not even allow a DBA to connect and perform any actions. In the SQL Server 2000 and earlier days, I often found myself restoring to a server reboot to get control of my database server.

412-977-3526 call/text

chris geswein Old Hand Points: 375 More actions · Answer 3

I think you have a typo in your first paragraph, last sentence. I think you meant resorting and not restoring.
That being said, I enjoyed the article. As someone whose had to use the DAC, I highly recommend leaving it open and available as a precaution!

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 4

chris geswein - Tuesday, October 2, 2018 8:51 AM
I think you have a typo in your first paragraph, last sentence. I think you meant resorting and not restoring.
That being said, I enjoyed the article. As someone whose had to use the DAC, I highly recommend leaving it open and available as a precaution!

Thanks, you are right and I've fixed it.

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 5

ildjarn.is.dead - Tuesday, October 2, 2018 3:58 AM
SSMS won't work, at least not with SSMS 17.9:

It does. What you'll find with SSMS is that it tries to make multiple connections. The second one fails, which is the error, but you often have either the OE or a query window connected.

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 6

robert.sterbal 56890 - Tuesday, October 2, 2018 8:33 AM
Administator should be Adminstrator in:
One of the best additions to the SQL Server feature set was the Dedicated Administator Connection (DAC). Prior to this being a part of the platform, an overloaded instance might not even allow a DBA to connect and perform any actions. In the SQL Server 2000 and earlier days, I often found myself restoring to a server reboot to get control of my database server.

Thanks, fixed.

johnfowler SSCommitted Points: 1520 More actions · Answer 7

Just for clarification, in SSMS you need to click the button for Database Engine Query:

Then type in "admin:<SERVERNAME>" in the Server name: field.

Sreekanth B SSCertifiable Points: 6145 More actions · Answer 8

See this Blog post to avoid confusion on establishing a DAC connection from SSMS.
https://mssqltrek.com/2018/06/28/dedicated-admin-connectiondac-from-ssms/