patternsqlMajor
Is it possible to estabilish Dedicated Administrator Connection (DAC) using SSMS?
Viewed 0 times
ssmsdacdedicatedpossibleusingadministratorestabilishconnection
Problem
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)
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)
Solution
This error occurs when you try to connect to DAC using the right click Connect and the Connect to Server dialog from the Object explorer
However, you can connect to DAC via SSMS by clicking the Database Engine Query button
The Connect To Database Engine dialog will pop out. Type the "admin:" prefix before the server name and you'll be connected to DAC
Hope this helps
However, you can connect to DAC via SSMS by clicking the Database Engine Query button
The Connect To Database Engine dialog will pop out. Type the "admin:" prefix before the server name and you'll be connected to DAC
Hope this helps
Context
StackExchange Database Administrators Q#17976, answer score: 20
Revisions (0)
No revisions yet.