DAC and Server is in single user mode – Error 18461

10 October,2013 by Jack Vamvas

I was working on an emergency fix of a TempDB  file location issue and had to create a Dedicated Administration Connection . I followed these instructions and successfully started the SQL Service

 Attempting to connect via the SQLCMD –A –E –S   switches , the following error message appeared

  

Msg 18461, Level 14, State 1, Server MYSERVER\SQL1, Line 1
Login failed for user 'MYDOMAIN\MYID'. Reason: Server is in single user mode. On
ly one administrator can connect at this time.

 

After staring at the screen (for a short while) , I realised other services exist automatically taking a connection. Checking services , I turned off : SQL Server Integration Services and SQL Server Browser.   Only the SQL Server Database Engine Services was started. I could now connect via the Dedicated Administration Connection

Read More

Error 18456 - State 5 - SQL Login Failed - SQL Server DBA

Forgotten sa password - SQL Server DBA

SQL Server – Find SQL Server tcp port with Powershell - SQL Server ...


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on DAC and Server is in single user mode – Error 18461


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer