Sql-server – SQL Server Management Studio DAC connection error

connectivitydacsql serversql-server-2012

I'm trying to connect to SQL Server 2012 via DAC using Management Studio. I type admin: before my server name, yet I keep getting the same error:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 – The remote computer refused the network connection.) (Microsoft SQL Server, Error: 1225)

What I've checked:

  • I can login with no problems when using regular connection(non DAC)
  • I can also login when forcing tcp: in connection string
  • user is a sysadmin (sa)
  • I am logging in from a local server (physical sql machine)
  • SQL Server browser is enabled
  • Remote connections are enabled and firewall was disabled
  • TcpDynamicPorts in regedit was set to 59036

  • I've executed this: 

    exec sp_configure 'show advanced options', 1  
RECONFIGURE WITH OVERRIDE  
exec sp_configure 'remote admin connections', 1  
RECONFIGURE WITH OVERRIDE

So far, nothing has helped me.

Best Answer

TcpDynamicPorts in regedit was set to 59036

Your instance is named and is configured to use dynamic ports. The default instance is listening on 1433 for all the connections and on 1434 for DAC, your port for DAC is still unknown but you can find it in error log:

xp_readerrorlog 0,1,N'Dedicated admin connection'

Then you need to check that it's open in your firewall and you can connect specifying directly this port:

myPCname,port
Related Question