reference, tutorial, tutorials, help, example, photoshop, html, php, mysql, 3d software, internet, graphics, programming, multimedia
Home >> Applications >> Database Servers >> MSSQL >>

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

Type: Code reference, tutorial, tutorials, help, example, photoshop, html, php, mysql, 3d software, internet, graphics, programming, multimedia
How to reset MSSQL sa user password from command line
Level: Beginner reference, tutorial, tutorials, help, example, photoshop, html, php, mysql, 3d software, internet, graphics, programming, multimedia 
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: 1638 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:                    
reference, tutorial, tutorials, help, example, photoshop, html, php, mysql, 3d software, internet, graphics, programming, multimedia - How to reset MSSQL sa user password from command line [1/1] - reference, tutorial, tutorials, help, example, photoshop, html, php, mysql, 3d software, internet, graphics, programming, multimedia

Need a specific tutorial? Do not hesitate and submit a request!
Related Tags: command line reset for mssql  reset MSSQL sa user password  mssql command line password  how to change the password from the command line on MSSQL Server or MSDE:  reset mssql password command  how to reset mssql user  reset mssql command  mssql sa "reset password"  how to reset mssql sa password  reset mssql sa password  reset MSSQL password console  reset user password + plesk  plesk user password reset  reset user password+plesk  command change password fro user in mysql  linux command to reset the plesk password  sa reset mssql  MSSQL\Binn reset sa  windows command line linux hostname -i command  how command line