Posts Tagged ‘change sql server password’

How to Change SQL Server Password

June 25th, 2012 by Admin

Forgot SQL Server password? A former employee forgot to leave you with the sa password for your SQL Server?  How to change the password or reset it? If you couldn’t fix this problem, you may have to reinstall SQL Server.  But if you have some very important data in the database, this may prevent you from reinstalling. Then, is there any effective way to recover or change SQL Server password?

This tutorial will explain how to change SQL Server password with SQL Server Password Changer, if you forgot sa password and can’t connect to your database using any user account. Once SQL Server is installed, a master.mdf file will be created and be used to stored the logins and passwords for all available SQL Server accounts. With SQL Server Password Changer you can easily change forgotten SQL Server passwords stored in the master.mdf database.

How to Change SQL Server Password:

  1. Download SQL Server Password Changer on your local PC, install and launch it.
  2. Click the Open File button. Select the SQL Server master database file (master.mdf). Typically it is located in the folder: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data.Select the SQL Server master database file
  3. The program will automatically decrypt the master database file and display all user accounts in your SQL Server. Select the SA account, click the Change Password button. Type a new password and click OK.SQL Server Password Recovery
  4. The old password will be replaced with your new password. Now you are able to log into the SA account using your new password.

Follow the steps above you can also change other user account passwords.  SQL Server Password Changer is a really useful utility and it can help you easily reset SQL Server passwords on SQL Server 2008/2005/2000.

Comments Off on How to Change SQL Server Password »

Posted in SQL Server, Tips & Tricks

Tags:

How to Change SA Password in SQL Server 2005

June 11th, 2012 by Admin

Forgot SQL Server password and unable to login using the SA account? If you happen to forget your SQL Server password for sa account, then here’s a simple query to help you reset it:

GO
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 the sa password, use this query:

ALTER LOGIN sa WITH PASSWORD = N'MyNewPassword' OLD_PASSWORD = 'MyOldPassword';
GO

You aslo can get a third-party tool to change SQL password. SQL Server Password Changer is one of the best MS SQL password reset tools which can help you change SQL Server password in a few seconds. It allows you to change SQL sa password on SQL Server and Express 2000/2005/2008.

Comments Off on How to Change SA Password in SQL Server 2005 »

Posted in Others, SQL Server, Tips & Tricks

Tags: