Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1785
  • Last Modified:

unlock the sa account in SQL 2005

How do you unlock the sa account in SQL 2005.
0
pronetsol
Asked:
pronetsol
  • 3
1 Solution
 
Anthony PerkinsCommented:
You use a valid password ...
0
 
Ved Prakash AgrawalDatabase Consultant/Performance ArchitectCommented:
you can login with windows Authentcation and then changes the password of sa account.

for run below satement you should need to be a part of db owner.

sp_password NULL,'new password','sa'
0
 
Anthony PerkinsCommented:
Please skip me and award all points to ved17nov
0
 
Anthony PerkinsCommented:
ee_ai_construct,

I suspect you may have missed my comment.

Anthony
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now