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

aj (ronald@[EMAIL PROTECTED]
) writes:
> I found a workaround.  I simply used SQLCMD rather than Mgmt Studio.  I 
> guess Mgmt Studio must be trying to make a 2nd connection somehow, but
> I don't know why.  I scripted this out on my test server beforehand, and
> Mgmt Studio connected just fine....   <scratching head>...
 
If you have set up Mgmt Studio to open both a query window and an 
Object Explorer when you startup, there will be two connections.

Not talking how funny this will be in SQL 2008 with intellisense,
which opens a second connection behind your back.


-- 
Erland Sommarskog, SQL Server MVP, esquel@[EMAIL PROTECTED]
 Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx