SQL server DAC connection to mssqlsystemresource database I have a problem while connecting to the mssqlsystemresource database. 

When I try to connect with DAC connection (without restarting SQL server with -m option) it works, but I can't use the mssqlsystemresource database, because the server is not in Single User mode. The only way to use this database is to restart the SQL server in Single user mode.

But once I restart the server with -m option I can no longer connect with DAC connection. I get this error:  


  the server is on Single-user mode, only an admin can connect to the
  server at this moment, SQL error 18461



I'm using SSMS on the same server so no need to verify the firewall 
I have SQL Browser service running 
I'm using a member of the sysadmin group
I have no other DAC connection to this server






I don't know what to do next. Any help, please?
I just managed to connect to my SQL Server using DAC, where the SQL Server was started in single user mode. I verified single user mode by looking in the errorlog file.

Using SSMS is not a reliable way to use the DAC or single user mode. SSMS has a tendency to open several connections, and you never know which one comes first - even for a single query window. I used SQLCMD. I managed to connect using SSMS single query window as well, but again, sometimes it works sometimes not depending on the orders for the (background) connections you happen to get.

Use SQLCMD.EXE instead of SSMS.