SA password

[cellspam]

Hi all,

How can i reset the SA password?

Regards

 

[mrdenny]

You will need to log into the server as a user which has sysadmin rights (same rights as sa) and use the sp_password system stored procedure to change the password. You can also do this in SSMS/EM by double clicking on the sa account and typing in the new password in the boxes provided.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[cellspam]

i have the access but don't know how to use the "sp_password"

can you explain me how? please...

thanks

 

[markros]

Check

http://technet.microsoft.com/en-us/library/ms174428.aspx

 

[TysonLPrice]

For SQL 2005. I'm not sure if it would do you any good though. It just got my eye when the article was published. I'm not a DBA.

http://www.sqlservercentral.com/articles/Administration/68271/