Logging in to SQL Server after starting in single-user mode using –m, you might get the following:

Cannot connect to..

Additional information:
Login failed for user ‘DOMAIN\user’. Reason: Server is in single user mode. Only one
administrator can connect at this time. (Microsoft SQL Server, Error: 18461)


image


Workaround- try to stop the Reporting Services Service and/or the SQL Agent Service if running. This will ensure that only one connection is made by an administrator.

Thanks,
Lee

 

-----------------------------


Posted in: SQL Administration  Tags:
blog comments powered by Disqus

by Lee Everest, M.S.

Info

Poll

Do you use Azure or cloud in your organization?
Show Results

Ads

Search


Month List

Calendar

«  May 2012  »
MoTuWeThFrSaSu
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910
View posts in large calendar

Tags

Disclaimer
The opinions, code, examples, et.al. expressed herein are my own personal opinions and do not represent my employer's view in any way, shape form, or fashion.  All code for demonstration purposes - no guarantees, either written or implied, are made.

© Copyright 2012 Lee Everest's SQL Server, etc. weblog