Retrieve the password of sa account

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Retrieve the password of sa account

15 posts, Page 2 of 2

««1 2

Retrieve the password of sa account

Rate Topic

Display Mode

Topic Options

Author

Message

Raamamohan

Posted Monday, November 23, 2009 11:02 PM

Old Hand

Group: General Forum Members
Last Login: Friday, February 15, 2013 11:18 PM
Points: 359, Visits: 111

How to retrieve Password in SQL 2005 witout creating/logging windows authentication?

Also how to identify passwords using TSQL or through VB programme

Post #823673

K. Brian Kelley

Posted Tuesday, November 24, 2009 9:13 AM

Keeper of the Duck

Group: Moderators
Last Login: Today @ 1:55 PM
Points: 6,584, Visits: 1,789

If you have locked yourself out of SQL Server, look at single-user mode. As far as retrieving passwords? Can't be done. SQL Server stores a hash of the password, not the actual password. You can use a tool like NGS SQuirreL for SQL Server, which will brute force the password, but it's not actually a retrieval.

K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog |

LinkedIn | Twitter

Post #823964

barry555

Posted Tuesday, June 15, 2010 7:11 AM

Valued Member

Group: General Forum Members
Last Login: Friday, March 15, 2013 11:31 AM
Points: 60, Visits: 198

Hi Brian,

How do I get your solution to work on a server that is the DC?!

I'm running SQL Server 2008 on Windows Server 2008, and this server is the AD DC, and so there are no local accounts.

I stupidly removed the Administrator login in SQL Server Management Studio, and I don't know the sa password!

Regards,

Barry

Post #937463

barry555

Posted Tuesday, June 15, 2010 3:22 PM

Valued Member

Group: General Forum Members
Last Login: Friday, March 15, 2013 11:31 AM
Points: 60, Visits: 198

Apologies Brian, please ignore my previous post. I was able to carry out your procedure using the domain admin account.

It failed the first time because I hadn't closed ALL the SQL Server services and so it was erroring saying there was another user logged in.

I've now back in and all is well with the world!

Many thanks,

Barry

Post #937854

MichelleChan

Posted Monday, May 30, 2011 8:44 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, June 21, 2011 9:37 PM
Points: 2, Visits: 9

Forgot MS SQL Server SA password? SmartKey SQL Password Recovery is a professional MS SQL Server password recovery utility that can easily help to reset lost or forgotten MS SQL Server SA password in minutes without data loss.No matter how long and complex your SA passwords are, SQL Password Recovery can 100% guaranteed to instantly reset user and administrator Passwords for Microsoft SQL Server 2000/2005/2008
Source:http://recoverlostpassword.com/products/sqlpasswordrecovery.html

Post #1117171

« Prev Topic | Next Topic »

15 posts, Page 2 of 2

««1 2

Permissions