Sunday, 5 January 2014

SQL Server User Authentication Failed (Login Failed for the user, Account disabled ,error 18470 )

Today , I faced this error while trying to login through user sa.

Nothing to worry at this error, because the solution to this issue is very simple. Just follow the below steps and you will be able do login through SQL Server Authentication Mode.

  1.  Login through Windows Authentication Mode. 
  2. Right click your SQL Server Instance and select the properties section. 
  3. In properties of SQL Server Instance, you will find Security tab on the left side. Click that.
  4. In the Security section you will find the option SQL Server and windows Authentication Mode under the Server Authentication Section.
  5. Select the SQL Server and windows Authentication Mode
  6. After that, you have to Enable the User Account 
  7. Select Logins from SSMS -> Security -> Logins
  8. In the Logins , you will find users . Right Click the user for which you want to enable the account. In my case it was sa
  9. Select the properties of that user.
  10. You will find the status section at the left of that properties window.
  11. Select that, there you will find the Enable and Disable options under the Login. Select the option Enabled and try again login through SQL Server  Authentication. 




No comments:

Post a Comment