Re: sa account locked out
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Fri, 26 Oct 2007 21:53:07 +0000 (UTC)
J. Cairn (jcairn@xxxxxxxxxxxxx) writes:
I am getting a message that my sa account is locked out, and I can't
connect with SQL Server Management Studio.
Other posts say to log in using Windows auth, but that is not letting
me in either. I am logged into the machine as the administrator and
SQL is set to mixed mode authentication. For security, I previously
removed the Windows accounts from SQL, including builtin
\adminstrators.
Any ideas? Thanks.
Looks like you are in dire straits. You need sysadmin to unlock sa, but
you don't have an sysadmin access available.
If you really must need access to this master database, you could open a
case with Microsoft to see if they have any tricks up their sleeve.
Else, it seems that you need to reinstall. You can attach the user
databases later on.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books 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
.
- References:
- sa account locked out
- From: J. Cairn
- sa account locked out
- Prev by Date: sa account locked out
- Next by Date: Re: Stored Procs in SQL 2005
- Previous by thread: sa account locked out
- Next by thread: Re: sa account locked out
- Index(es):
Relevant Pages
|
|
