Solved

SQL 2008 how to reset sa password

Posted on 2012-04-05
5
277 Views
Last Modified: 2012-04-28
SQL 2008 how to reset sa password if I forgot the password.
0
Comment
Question by:Bharat Guru
5 Comments
 
LVL 13

Expert Comment

by:Ashok
ID: 37812417
0
 
LVL 29

Expert Comment

by:Paul Jackson
ID: 37812423
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
 
LVL 13

Expert Comment

by:Ashok
ID: 37812439
Use Option 1

Login into SQL Server using Windows Authentication.

HTH
Ashok
0
 
LVL 5

Accepted Solution

by:
25112 earned 155 total points
ID: 37814874
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
 

Author Closing Comment

by:Bharat Guru
ID: 37906108
Thanks
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question