October 2, 2018 at 12:04 am
Comments posted to this topic are about the item Who's Using the DAC?
October 2, 2018 at 3:58 am
SSMS won't work, at least not with SSMS 17.9:
October 2, 2018 at 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.
412-977-3526 call/text
October 2, 2018 at 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!
October 2, 2018 at 11:22 am
chris geswein - Tuesday, October 2, 2018 8:51 AMI 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.
October 2, 2018 at 11:23 am
ildjarn.is.dead - Tuesday, October 2, 2018 3:58 AMSSMS 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.
October 2, 2018 at 11:24 am
robert.sterbal 56890 - Tuesday, October 2, 2018 8:33 AMAdministator 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.
October 3, 2018 at 2:30 pm
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.
October 4, 2018 at 8:16 am
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