Severity 20 Error upon disconnecting Dedicated Administrator Connection
2
votes
0
answers
895
views
Starting working with Dedicated Administrator Connections on SQL Server 2008 R2 servers. All is working fine (once port 1434 was opened), but am getting severity 20 errors when I disconnect the admin connection.
From within SSMS, I am opening a new query window then connecting via the DAC using connection string, "admin:". All is well. However, when I disconnect, my SQL Alert for Severity 20 errors fires, alerting me to it. The description of the alert reads:
> "Could not connect because the maximum number of ‘1’ dedicated
> administrator connections already exists. Before a new connection can
> be made, the existing dedicated administrator connection must be
> dropped, either by logging off or ending the process. [CLIENT:
> XX.XX.XX.XX]" The IP address is mine.
I'm confused as what could be attempting the connection at the same time I am disconnecting from the DAC. Or, is it something else. No connections to the same server from my SSMS via any query window or Object Explorer. Other users may be connecting to this SQL Server (its a dev box) but not on DAC (only opened port 1434 before testing).
Any thoughts?
Asked by CJ Gregory
(21 rep)
Jan 27, 2015, 03:59 PM
Last activity: Sep 4, 2018, 06:53 PM
Last activity: Sep 4, 2018, 06:53 PM