August 18, 2009 at 10:12 pm
Hi,
I have moved SQL server 2005 databases from one instance on server A to another instance on Server B.
I used backup & restore method and then script out the logins in server A and applied in server B. Everything wen well. There is a login with NO password & I disabled it for some reason and now I'm trying to enable that login but its giving me the below error
TITLE: Microsoft SQL Server Management Studio
------------------------------
Enable Login. failed for Login 'ABC'. (Microsoft.SqlServer.Smo)
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot enable a login that has an empty password. (Microsoft SQL Server, Error: 15510)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4035&EvtSrc=MSSQLServer&EvtID=15510&LinkId=20476
------------------------------
BUTTONS:
OK
August 19, 2009 at 9:24 am
add a password for the account
enable the account
remove the password if you want to
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
August 19, 2009 at 10:25 am
The whole application is using this login. If I entere a password, then application will fail to connect to sql server.
My Question is, if I enter the password & enable the login and then removing the password is same as having no password??
thanks
August 21, 2009 at 1:13 pm
You should look at seeing if you can change the application. Failing that:
1. Set a password on the login.
2. Ensure password policy enforcement is OFF.
3. Enable the login.
4. Modify the password to be blank. Accept the warning that you're given.
And the login will be enabled with a blank login. If this SQL Server is accessible from the network, though, you've got a rather giant security hole in your SQL Server. So be advised of that. Should you be audited, that will be something your auditors will likely flag as needing to be fixed immediately.
K. Brian Kelley
@kbriankelley
August 27, 2009 at 11:32 am
1. Set a password on the login.
2. Ensure password policy enforcement is OFF.
3. Enable the login.
4. Modify the password to be blank. Accept the warning that you're given.
the above steps worked. As having blank password is security threat, I requested the application folks to use the password.
Lets see what they propose..
thank you
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply