how to change sql server login password?

Question

hello.

iam using SqlServer 2008r2 and my pc is in the network (in an office)

how can change my login password which is created in SQl server authentication?

Answer 1

Hi,

This should work

ALTER LOGIN yoursqllogin WITH PASSWORD = 'newpassword' OLD_PASSWORD = 'oldpassword'

Answer 2

Hi Ehsan

• 1. Login into SQL server using Windows Authentication.
• 2. In Object Explorer, open Security folder, open Logins folder. Right Click on sa account and go to Properties.
• 3. Type a new SQL LOGIN password, and confirm it. Click OK to finish.

From A query Window you can try this

• Step 1. Open SQL Server Management Studio
• Step 2. Open a new query
• Step 3. Type the follow commands and excute:
  GO
  ALTER LOGIN [LOGIN_NAME] WITH DEFAULT_DATABASE=[master]
  GO
  USE [master]
  GO
  ALTER LOGIN [LOGIN_NAME] WITH PASSWORD=N’NewPassword’ MUST_CHANGE
  GO

Hope this helps you

Answer 3

Hi,

• 1. Login into SQL server using Windows Authentication.
  2. In Object Explorer, open Security folder, open Logins folder. Right Click on sa account and go to Properties.
  3. Type a new SQL sa password, and confirm it. Click OK to finish.
  After restarting SQL Server and all its services, you can log into SQL Server by sa login with new SQL sa password.

To chainge through Query Analyser

• Change SQL Server Password with the Query Windows in Management Studio
  Step 1. Open SQL Server Management Studio
  Step 2. Open a new query
  Step 3. Type the follow commands and excute:
  GO
  ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]
  GO
  USE [master]
  GO
  ALTER LOGIN [sa] WITH PASSWORD=N’NewPassword’ MUST_CHANGE
  GO
  Then the new password is set for your SQL Server sa account.
  

---

Please click the Mark as Answer or Vote As Helpful button if a post solves your problem or is helpful!

Answer 4

To change sql server 2008 password by the following methods.

Method 1: Change SA password SQL server 2008 by Windows Authentication

If Built-in/Administrator is present in SQL 2008 Server, you can login with an ID which is member of Administrators group and reset SA password in SQL Server. Just do as follows:
Step 1. Login into SQL 2008 server using Windows Authentication.
Step 2. In Object Explorer, open Security folder, open Logins folder. Right click on sa account and go to Properties.
Step 3. Type a new SQL SA password, and confirm it. Click OK to finish.

Method 2: changeSQL server 2008 password with Smartkey SQL Password Recovery

Step 1: Download SQL server 2008 password reset software and install it on your computer.
Step 2: Run the software, when see the interface, click Open to load the master .mdf file. All the user names of your SQL Server will be displayed.
Step 3: Select the password forgotten account, here the forgotten password account is SA, select it.
Step 4: Click “Change Password” button, then choose the new password in the “Change Password” panel, and then click OK to finish modification.

Answer 5

You can Change SQL Server Login Password using SQL Server Login Password Change Utility which is provided by SQL Password Recovery Software.