Networking, Programming and Graphics Tutorials
Home >> Applications >> Database Servers >> MSSQL >>

How to reset MSSQL sa user password from command line [1/1]

Type: Code Networking, Programming and Graphics Tutorials
How to reset MSSQL sa user password from command line
Level: Beginner Networking, Programming and Graphics Tutorials 
How to reset MSSQL sa user password from command line
Date: 2007-Apr-07
How to reset MSSQL sa user password from command line
Visited: 1827 times
How to reset MSSQL sa user password from command line
Rating: How to reset MSSQL sa user password from command line
How to reset MSSQL sa user password from command line
Author: Stephen Think

This tutorial will show you how to change the password from the command line on MSSQL Server or MSDE.

1.Open a command prompt window by selecting "Start"-->"Run...", and typing "cmd.exe" in the "Run" dialog box.
2.Change to the directory in which the MSSQL or MSDE utilities are stored (this is usually C:\MSDE\binn, C:\Program Files\MSSQL\binn, etc.).
3.Type the following command where <newpassword> is the password you have chosen:

osql -U sa -P "" -Q "sp_password NULL,<newpassword>,sa"
Rate this tutorial:                    
Networking, Programming and Graphics Tutorials - How to reset MSSQL sa user password from command line [1/1] - Networking, Programming and Graphics Tutorials

Need a specific tutorial? Do not hesitate and submit a request!
Related Tags: command line reset for mssql  reset MSSQL sa user password  Reset User password MSSQL  mssql command line password  reset mssql password command  how to change the password from the command line on MSSQL Server or MSDE:  reset sa password command line  how to reset mssql user  mssql command line  run mssql from command line  mssql command line tutorial  sa +password +mssql +cmd +line  reset mssql command  mssql sa "reset password"  how to reset mssql sa password  reset mssql sa password  reset MSSQL password  reset MSSQL password console  reset mssql password msde  windows ftp -s command line batch user open put auto login