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


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 1:13 AM
Points: 482, Visits: 118
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: Monday, August 18, 2014 8:24 AM
Points: 6,634, Visits: 1,871
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
Posted Monday, May 19, 2014 4:18 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 24, 2014 10:47 PM
Points: 22, Visits: 37
Change SA Password in SQL Server Using SQL Server Management Studio

1.Connect to SQL Server Using SQL Server Management Studio 2. Expand Security -> Logins -> Right click sa to open up Login Properties in SQl management studio, Login section.


SSMS Expert
Post #1572203
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse