Knowledgebase
(28)Applications (16)DNS (23)Domains (9)Downloads (61)eMail (5)File Transfer Protocol (144)Flash Tutorials (18)General (11)IIS (4)Migrations (30)MSSQL Server (10)MySQL Server (74)Plesk Panel (2)Security and Hack (9)SEO (3)Server Settings (10)Services (3)SSL Certificates (9)Your Account
SEARCH
Knowledgebase
Login failed for user 'sa'. Reason: The account is disabled. SQL Server
Posted by on 08 August 2012 11: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.
(8 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).