Sample Header Ad - 728x90

Is it possible to estabilish Dedicated Administrator Connection (DAC) using SSMS?

16 votes
3 answers
12376 views
Is it possible to connect to the DAC using SSMS? If I understand correctly, it should be possible by using "admin:" prefix before the server name, but I receive the following message: > Dedicated administrator connections are not supported via SSMS as it > establishes multiple connections by design. > (Microsoft.SqlServer.Management.SqlStudio.Explorer)
Asked by user6426
May 16, 2012, 02:32 PM
Last activity: Sep 29, 2022, 07:41 PM