Who's Using the DAC?

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

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

  • 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

  • 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!

  • 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.

  • 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.

  • 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.

  • 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.

  • 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/

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

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