Andreds


Is anyone familiar with the following error message :

"Login failed for user 'username'. Reason: The account is disabled. (Microsoft SQL Server, Error: 18470)"

I just started learnig SQL Server 2005. I downloaded the Express edition, and created a test DB, but now I cannot connect to the Database Engine.




Re: "Login failed for user 'username'. Reason: The account is disabled. (Microsoft SQL Server, Error: 18470)"

Madhu K Nair


The error says that the particular Login is Disabled.

(a)Expand the SQL Server

(c) Expand Security node

(d) Select the Particular Login (User)

(e) Press right button and select properties of the login

(f) Go to Status table Enble the User

Then try to login

Madhu







Re: "Login failed for user 'username'. Reason: The account is disabled. (Microsoft SQL Server, Error: 18470)"

Joe Webb

You can also use the following statement in a query window to accomplish the same:

Code Block

ALTER LOGIN login_in_name ENABLE;



For more information, check out ALTER LOGIN in MSDN.
http://msdn2.microsoft.com/en-us/library/ms189828.aspx

HTH...

Joe