Knowledgebase: MSSQL Server
Login failed for user 'sa'. Reason: The account is disabled. SQL Server
Posted by Sean Syed on 23 February 2013 05:47 PM
As the error says the particular login is Disabled. Thus, we need to enable the user.

Follow these steps to enable the user.
  1. Go to start -> programs.
  2. Open Sql server management studio
  3. Login to the SQL server (using windows authentication).
  4. Expand the security tab.
  5. Expand the Login folder.
  6. Select the user for which you got this error. In this case 'sa'.
  7. Right click and select properties.
  8. Enable the user.
  9. Save settings.
(20 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).