I recently enabled DAC and noticed this error when first trying to connect with object explorer in SSMS:
Cannot connect to admin:servername
Dedicated administrator connections are not supported via SSMS as it establishes multiple connections by design. (Microsoft.SqlServer.Management.SqlStudio.Explorer)
It works fine via sqlcmd or just doing File>New>Database Engine Query.
My question is, how many default connections are made when you connect to a server in Object Explorer? I would guess if you have it configured to spawn a new query window that would be another connection? The SQL Server Agent?
I understand this answer: Is it possible to estabilish Dedicated Administrator Connection (DAC) using SSMS? but I was just curious what connections are made by default.
Thanks!
