Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Retrieve the password of sa account Expand / Collapse
Author
Message
Posted Monday, November 23, 2009 11:02 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld 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
Posted Tuesday, November 24, 2009 9:13 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Thursday, April 03, 2014 10:06 PM
Points: 6,621, Visits: 1,851
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
Posted Tuesday, June 15, 2010 7:11 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, June 25, 2013 9:47 AM
Points: 60, Visits: 207
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
Posted Tuesday, June 15, 2010 3:22 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, June 25, 2013 9:47 AM
Points: 60, Visits: 207
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
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse