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: 292
  • Last Modified:

SQL 2008 how to reset sa password

SQL 2008 how to reset sa password if I forgot the password.
0
Bharat Guru
Asked:
Bharat Guru
1 Solution
 
Paul JacksonCommented:
Can you connect to the server with another sysadmin account through SQL Server Management Studio, if so just expand the security folder, click on Logins, right click the sa account and select properties and you can reset the password on the property page
0
 
AshokCommented:
Use Option 1

Login into SQL Server using Windows Authentication.

HTH
Ashok
0
 
25112Commented:
If you do not have any other sysadmin accounts, then the only option is to reinstall sql server. but hopefully you have at least one sysadmin account- then you can go in and change the sa password, like the above recommendations..
0
 
Bharat GuruAuthor Commented:
Thanks
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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