Start a conversation

Login failed for user 'sa'. Reason: The account is disabled. SQL Server

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.
Choose files or drag and drop files
Was this article helpful?
  1. Senior Engineer Jessie

  2. Posted
  3. Updated