Results 1 to 1 of 1
-
9th Feb 2012, 10:58 AM #1OPMemberWebsite's:
AVANETCO.COM AVAVPS.COMHow to Change MSSQL 'SA' password
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..Albert.Nawaro Reviewed by Albert.Nawaro on . How to Change MSSQL 'SA' password 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 Rating: 5
Sponsored Links
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Similar Threads
-
60-days force password change
By Newz in forum Feedback and SuggestionsReplies: 16Last Post: 7th Oct 2012, 11:13 AM -
How can I change TF password
By deccter in forum Server ManagementReplies: 8Last Post: 29th Nov 2010, 12:29 PM -
Password: Change it
By el_jentel1 in forum News and AnnouncementsReplies: 0Last Post: 8th Jun 2010, 12:36 AM -
How To Change MYSQL User Password?
By desibreaker in forum Webmaster DiscussionReplies: 2Last Post: 25th Mar 2010, 04:29 AM
themaCreator - create posts from...
Version 3.24 released. Open older version (or...