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?