How many connections does Object Explorer use in SSMS?
1
vote
0
answers
155
views
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: https://dba.stackexchange.com/questions/17976/is-it-possible-to-estabilish-dedicated-administrator-connection-dac-using-ssms but I was just curious what connections are made by default.
Thanks!
Asked by Ross
(91 rep)
Nov 5, 2019, 01:31 PM