Solved

SQL 2008 how to reset sa password

Posted on 2012-04-05
5
279 Views
Last Modified: 2012-04-28
SQL 2008 how to reset sa password if I forgot the password.
0
Comment
Question by:Bharat Guru
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

735 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