Post reply

Can't connect to DAC connection through SSMS

  • September 7, 2018 at 1:46 pm

    #372353

    Hello - 

    I'm trying to connect to the DAC through SSMS 17.8.1 using the ADMIN:INSTANCENAME syntax, but I keep getting the following error:
    Dedicated Administrator connections are not supported via SSMS as it establishes multiple connections by design.

    Is this the new functionality in SSMS 17, or do I have another problem?  Thanks in advance.

  • September 7, 2018 at 2:31 pm

    #2004945

    Not a new functionality. As it says, SSMS default "connect to server" will open multiple connections(Object explorer). The trick is to connect using query pane or thru "Database Engine Query". The below blog post explains it in detail...
    https://mssqltrek.com/2018/06/28/dedicated-admin-connectiondac-from-ssms/

  • September 10, 2018 at 8:00 am

    #2005075

    There are times you'll get this but if you look at your current query, it can be connected with the DAC, but you've gotten an error from the Object Explorer or another object.

  • September 10, 2018 at 3:48 pm

    #2005159

    Thank you for your respnses

Viewing 4 posts - 1 through 3 (of 3 total)

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