Re: SQL 2005 express blank sa passwords
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 11 Apr 2007 22:03:19 +0000 (UTC)
jaylou (jaylou@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I just upgraded to SQL 2005 express on one of my remote branches. When
it was SQL2000 the DBA before me set the passwords to blank for ease as
opposed to entering in a password. there are many application and
procedures that run off the SA login. for now until I find everything
that uses the Sa login, I need to set the password to blank.
Is there a way to set the sa pasword to blank in SQL 2005 express? When I
try it disables the login.
I set the password for sa to blank, and then I tried
ALTER LOGIN sa ENABLE
and I was told that I cannot enable an account with a blank password. That
makes me quite certain that the answer to your question is no.
I suggest that you get a voodoo doll of that former DBA, and some really
ugly pins to stick into it.
I would also recommend that when you review the applications that you
look into Windows authentication.
--
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
.
- Prev by Date: Re: Schema as a security mechanism?
- Next by Date: Re: Disable SQL login possible?
- Previous by thread: Re: Schema as a security mechanism?
- Next by thread: Re: Disable SQL login possible?
- Index(es):
Relevant Pages
|
|
