Sample Header Ad - 728x90

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