Albert.Nawaro
Active Member
Hi,
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
Code:
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:
Code:
sp_password NULL,'new_password','sa' go
Now try to login to MSSQL using new password..
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
Code:
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:
Code:
sp_password NULL,'new_password','sa' go
Now try to login to MSSQL using new password..