locked sa login

• Shahrukh Khan

  SSC-Addicted

  Points: 430

  More actions

  April 25, 2009 at 11:12 am

  #133540

  Hello,

  My 'sa' login is locked. How can we unlock it?

  Thanks,

  SRK.

• John H Marsh

  SSChampion

  Points: 11671

  More actions

  April 25, 2009 at 11:45 am

  #983996

  Hello,

  Open up SSMS using a Login who is in the SysAdmin role on the SQL Server e.g. a Member of the Administrators Group on the Windows Server.

  In the Object Explorer Window, navigate to the Security, Logins, SA Properties pages. You can then Enable the SA Login.

  Also worth checking if the SQL Server is setup for Mixed Mode, or just Windows Authentication.

  Regards,

  John Marsh

  www.sql.lu
  SQL Server Luxembourg User Group

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  April 27, 2009 at 7:22 pm

  #984802

  Execute this:

  ALTER LOGIN sa WITH PASSWORD = ‘your_password_here‘ UNLOCK

  MJ