none
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?
    Saturday, June 16, 2012 6:02 AM

Answers

  • 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

    • Marked as answer by great ehsan Saturday, June 16, 2012 6:01 PM
    Saturday, June 16, 2012 7:21 AM
  • Hi,

    This should work

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

    • Marked as answer by great ehsan Saturday, June 16, 2012 6:01 PM
    Saturday, June 16, 2012 6:30 AM
  • 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!

    • Marked as answer by great ehsan Saturday, June 16, 2012 6:02 PM
    Saturday, June 16, 2012 8:22 AM

All replies

  • Hi,

    This should work

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

    • Marked as answer by great ehsan Saturday, June 16, 2012 6:01 PM
    Saturday, June 16, 2012 6:30 AM
  • 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

    • Marked as answer by great ehsan Saturday, June 16, 2012 6:01 PM
    Saturday, June 16, 2012 7:21 AM
  • 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!

    • Marked as answer by great ehsan Saturday, June 16, 2012 6:02 PM
    Saturday, June 16, 2012 8:22 AM
  • 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.

    Wednesday, June 20, 2012 3:47 AM
  • You can Change SQL Server Login Password using SQL Server Login Password Change Utility which is provided by SQL Password Recovery Software.
    Tuesday, April 02, 2013 10:59 AM
  • how can change my login password which is created in SQL server authentication?

    The system administrator has the right to change the password or to reset a new password for SQL Server login. Or if, somehow, if the system administrator is not available at that moment, a third-party SQL Server password recovery tool would be an ideal solution. 

    Try SysInfoTools MS SQL Password Recovery to reset new password for SQL Server logins, both individual user as well as system administrator. To read more about this software, visit: http://www.sysinfotools.com/sql-server-password-recovery.html 

    Thanks.

    Wednesday, November 20, 2013 10:47 AM
  • The SQL Server application is used for maintaining highly professional data and is installed on a primary server for allowing access to varied number of users. This enables SQL Server to create individual logins for different users which further enables them to manage and modify databases over a secured channel. User login details for each SQL database play a significant role.

    But Without correct login credentials, it becomes impossible for anyone to enter into secured database which makes the entire system safer and theft free. Here SysInfoTools provide a perfect solution to reset your sql server password manually

    for more detail visit: http://sysinfotools.com/blog/reset-sql-server-passwords/

    Hope it will help you!

    8 hours 54 minutes ago