How to reset a sql 2000 password

[Walter89]

I have some computer running on sql server in my office. I am using Ms SQL Server 2000. For a security issue i want to reset the password script for the complete system. Changing the password at a particular interval of time enhances the safety of data and other security related matter. When i try do so i got errors while re-login. Suggest some way to reset the password of sql server 2000.

[Milton.J]

Many security personals recommends that changing the password make your security more strong. It is quiet easy to change the password on a SQL server 2000. You can do this by Query Analyzer. Query Analyzer works good in changing a password. It provides the flexibility to change the password at the most appropriate time.
To change the server username password, first connect to the database with Query Analyzer. Login by username and password. Then run the following command -

sp_password [ [ @old = ] 'old_password' , ]
{ [ @new =] 'new_password' }
[ , [ @loginame = ] 'login' ]

Be sure that you use a strong password for your security matters.

[Spyrus]

You can easily changeyour SA Login password by Using Microsoft SQL Server Management Studio. Login to the server using Windows Authentication.

• In the left of window in Object Explorer go to Security Folder > Open Logins Folder.
• Right click on the SA Acount > Select Properties.
• Go to General > Change the SA password and click OK.
• Restart the complete system and relogin.

If you want you can periodically change the password.

[Snake08]

Give the below command the change the password.

osql -E -d mf_enterprise -Q "sp_password NULL, 'newpassword', 'sa'"

Or else try this one also :
Login as an administrator. Run a Query Analyzer and run sp_password command :
sp_password @new = 'xxxxxxxx', @loginame = 'sa'
xxxxx is the place where you will type your new password.

[yudopajdkla]

I used MS SQL Server Password Unlocker to reset SQL password when I forgot the MS SQL password a few days ago. I took two days to find a capable solutions but arrive no result. Fortunately, one of my class mates recommended me to reset the sql password with MS SQL Server Password Unlocker ; it is fast and easy to use, but no data loss.

[Reema_n]

Hi Friend,

Have you tried below steps to reset a sql 2000 password?

1. Initially confirm your system is connected to the Internet.
2. Then you need to run the "Query Analyzer".
3. Then select "DBP_DB1" from the "Connect to SQL Server" dialog box.
4. Then you need to choose the "Use SQL Server authentication" option.
5. Then please provide user name of your SQL Server and password which is supplied to you.
6. The click on "OK" to make connection with "SQL Server database"
7. After this connection finally you need to execute below query:
   "EXEC sp_password 'YourOldPassword','YourNewPassword'"