Post reply

SQL Error for DAC indicates a connection but its disabled (solved)

  • October 24, 2019 at 6:19 pm

    #3691727

    SQL 2016 SP2 CU7-GDR Enterprise

    Running Red-Gate SQL monitor on this server, we also have SolarWinds AppInsight monitoring this server.

    According to sys.configurations this is not enabled (maybe this is why we get the error).

    Nobody is trying to connect as far as i know.

    Error Entry:

    Date 10/24/2019 12:58:47 PM

    Log SQL Server (Current - 10/24/2019 1:04:00 PM)

    Source Logon

    Message

    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: 127.0.0.1]

    This happens a couple times per week, i'm not sure what triggering this.

    I've also run the following and always comes back blank.

    SELECT
    ses.login_name,
    ses.session_id,
    ses.login_time,
    ses.status,
    ses.original_login_name
    from sys.endpoints as en
    join sys.dm_exec_sessions ses on
    en.endpoint_id=ses.endpoint_id
    where en.name='Dedicated Admin Connection'

    I'm running dbatools powershell command:

    Start-DbaMigration -Source contoso01 -Destination contoso02 -Exclude SpConfigure, AgentServer, Databases -WhatIf -Verbose -Force

    That is what is triggering the log entry on the source server. Why i don't know but at least i know whats triggering it.

    • This topic was modified 4 years, 6 months ago by  TangoVictor.

  • October 25, 2019 at 7:10 pm

    #3692030

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply