Live Chat Software by NetForChoice
Knowledgebase: Data Base
How to change MSSQL 'sa' password?
Posted by on 08 July 2016 03:39 PM

 

SA login is the administrative login for the MSSQL.. To Change the MSSQL SA password you have to execute following commands from command prompt of your server:

1) Go to the command prompt of the server & type in command prompt osql -L
This command will list all the MSSQL servers near you.

2) Copy full name of required MSSQL server & type 

osql -S copied_servername -E

By this command you'll connect to MSSQL server using administrator account.
3) To change sa password you should execute the following query:

Quote:

 

sp_password NULL,'new_password','sa'
go

 

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
Help Desk Support from NetForChoice