password recovery studio

PASSWORD UNLOCKER

Password Reset and Password Recovery Tools

How to: Change ’sa’ password on SQL server 2008

Tuesday, 15. December 2009

If you happen to forget your SQL Server password for ’sa’ account, then here’s a simple query to help you reset it:

ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]

GO

USE [master]

GO

ALTER LOGIN [sa] WITH PASSWORD=N’MyNewPassword’ MUST_CHANGE

GO

In Case you remember your Old Password and want to change ’sa’ password, use this query:

ALTER LOGIN [sa] WITH PASSWORD = N’MyNewPassword’ OLD_PASSWORD = ‘MyOldPassword’;

GO

Posted in SQL password recovery by tina

2 Responses to “How to: Change ’sa’ password on SQL server 2008”

  1. January 10th, 2010 at 11:53 am

    spyware search Says:

    Thanks so very much for publishing this.

  2. September 7th, 2010 at 2:56 pm

    FERNANDO Says:


    CheapTabletsOnline.com. Canadian Health&Care.Best quality drugs.Special Internet Prices.No prescription online pharmacy. No prescription pills. Order drugs online…

    Buy:Ventolin.Prozac.Amoxicillin.Seroquel.Female Pink Viagra.Lasix.Zocor.Wellbutrin SR.Aricept.Cozaar.Acomplia.SleepWell.Nymphomax.Zetia.Lipothin.Advair.Buspar.Benicar.Lipitor.Female Cialis….

Leave a Reply