Change Password for SQL Server User
One of ways to boost security is changing passwords. It is also recommended by most security experts. Query Analyzer is an easy means to change the password on a SQL Server Username, since it easily coordinates changing the password on the database server at the same time as it is changed in the connection string. This approach provides the flexibility to change the password at the most appropriate time for the application.
How? Just connect to the database with Query Analyzer using the SQL Server Username that is being updated and the current password. Then run "sp_password" to change the password.
sp_password [ [ @old = ] 'old_password' , ]
{ [ @new =] 'new_password' }
[ , [ @loginame = ] 'login' ]
Here is a simple example that changes the current password from "currentPSWD" to "newPSWD":
sp_password 'currentPSWD', 'newPSWD'
It is important to use a sturdy password. "newPSWD" is just an example. Next, always test any change like this right away. For a quick test to confirm that the new password is working, close Query Analyzer and then re-connect with the new password. It is critical to have down pat to change the password in your connection string if this SQL Username is used in your code. You are through once the password has been changed and tested with Query Analyzer, update the connection string with the new password and test that everything still works correctly.
|
By Location