November 21, 2003 at 11:02 pm
hai friends,
can anybody tell me how to change user passwords for sqlserver2000,
particularly for the username 'sa'
Thanks/regards
suman cherukupalli.
November 22, 2003 at 5:23 am
I assume that you want to change passwords in T-SQL where you can use sp_password procedure:
sp_password 'old_password','new_password', 'login'
for example to change password for sa:
exec sp_password 'foo', 'zoo', 'sa'
There are few limitations, though: you have to be member of sysadmin or securityadmin
fixed server role, it cannot be executed inside transaction and it cannot be used to change
passwords on NT accounts. Read more in Books Online.
--
georged
--
George
November 24, 2003 at 1:15 am
on SQL server Enterprise Manager (EM):
1- go to security folder .. and expand it
2- go to logins
3- in the right area, you wil find "sa", so double click on it
4- in the "password" text box , write your new password
5- restart your SQL server (or restart your machine
I hope this helps you
Alamir Mohamed
Alamir Mohamed
Alamir_mohamed@yahoo.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply