Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Reset SA password

Author  Topic 

d3ng
Yak Posting Veteran

83 Posts

Posted - 2007-12-03 : 22:06:42
Hi experts, I would like to ask if there is a way to reset the SA password of SQL 2005 without having to know the current password?

Im using SQL 2005 Express

Thanks!

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-03 : 22:11:30
You don't need to know sa password if you are member of sysadmin.
Go to Top of Page

d3ng
Yak Posting Veteran

83 Posts

Posted - 2007-12-03 : 22:14:01
the problem was I was not able to include my account in sysadmin? is there a way how to add it manually? I was tryin to add it.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-03 : 22:28:30
Ask your sysadmin do it, not everyone can change sa password.
Go to Top of Page
   

- Advertisement -