How to change the 'sa' password in sql server.?
-
user:sa password how to change
-
Answer:
osql -E -d mf_enterprise -Q "sp_password NULL, 'newpassword', 'sa'" Or Login as an administrator then run - Run a Query Analyzer sp_password @new = 'your new password', @loginame = 'sa'
Yahoo! Answers Visit the source
Other answers
Open SQL Server Enterprice [2000] SQL Server Group -----> Local [Windows NT] -----> Security -----> Login Select sa user on Right Pane Right click on sa user than Properties type new password in password text box.
Related Q & A:
- How to increase application performance with Centralised SQL Server?Best solution by Database Administrators
- How to setup User and Password for Git server?Best solution by Stack Overflow
- How to present large dataset from a SQL Server query?Best solution by stackoverflow.com
- How to change wamp phpmyadmin password?Best solution by Stack Overflow
- How to change my Yahoo password?Best solution by Yahoo! Answers
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.