Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft SQL Server > Login failed fo...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 10962 of 11205
Post > Topic >>

Login failed for user 'sa'. Reason: Server is in single user mode.

by aj <ronald@[EMAIL PROTECTED] > Apr 14, 2008 at 10:17 AM

SQL Server 2005 SP2 2005.090.3054.00

I'm trying to move master/model/msdb to a new spot.  I restart SQL
Server in single user mode with the "-c;-m;-T3608" startup params.

When I try to connect to do the detach, I get:
Login failed for user 'sa'. Reason: Server is in single user mode. Only
one administrator can connect at this time. (Microsoft SQL Server,
Error: 18461)

But no one else is trying to connect....????

I have stopped all other services other than the main MSSQLSERVER server
instance.. same result..

Any ideas appreciated..

aj




 3 Posts in Topic:
Login failed for user 'sa'. Reason: Server is in single user mod
aj <ronald@[EMAIL PROT  2008-04-14 10:17:39 
Re: Login failed for user 'sa'. Reason: Server is in single user
aj <ronald@[EMAIL PROT  2008-04-14 17:51:45 
Re: Login failed for user 'sa'. Reason: Server is in single user
Erland Sommarskog <esq  2008-04-16 06:17:31 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sat Jul 5 5:00:46 CDT 2008.