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»»

lost passwords--any hope? Expand / Collapse
Author
Message
Posted Tuesday, May 4, 2010 3:08 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 9, 2010 7:58 PM
Points: 121, Visits: 195
This has probably been asked before. Small company, the former IT people long gone. A SQL Server 2005 database exists, but there's no record of any loginname/password, including sa. And yes, we did try sa and blank. Is there any hope?
Post #915685
Posted Tuesday, May 4, 2010 3:16 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 5:44 PM
Points: 1,291, Visits: 2,771
Do have the administrator password to the Windows server administrator account that the database instance resides on? If so, and if the former admin did not remove the BUILTIN/administrators group from the 'sysadmin' role, you should be able to log in to the database instance using Windows Authentication.

----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------

Yeah, well...The Dude abides.
Post #915686
Posted Tuesday, May 4, 2010 3:25 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 9, 2010 7:58 PM
Points: 121, Visits: 195
Sorry I should have mentioned I tried that.
Post #915694
Posted Tuesday, May 4, 2010 3:27 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 5:44 PM
Points: 1,291, Visits: 2,771
Try single user mode then:

http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx


----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------

Yeah, well...The Dude abides.
Post #915698
Posted Tuesday, May 4, 2010 7:52 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 3:37 PM
Points: 4,389, Visits: 9,522
Before taking the system down and putting SQL Server in single user mode, try adding your windows domain account to the SQL Server specific windows groups on the server. Those groups, by default - have sysadmin rights to SQL Server.

You should be able to add your account and then login using windows authentication.


Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #915772
Posted Tuesday, May 4, 2010 8:30 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:50 AM
Points: 12,903, Visits: 31,970
i think you can use the Surface Area Configuration tool to add yourself as an administrator, and then change the passwords of the lost admins, including "sa", right?


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #915778
Posted Tuesday, May 4, 2010 8:34 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 3:37 PM
Points: 4,389, Visits: 9,522
Lowell, if that functionality adds the users to the right local windows groups - then yes, that should work. If it doesn't, then it will need to login to SQL Server with admin rights - which isn't known.

My bet is that it adds the user(s) to the appropriate windows groups and not to SQL Server.


Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #915780
Posted Wednesday, May 5, 2010 7:49 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 9, 2010 7:58 PM
Points: 121, Visits: 195
I'm not sure what you mean by SQL Server-specific windows groups.
Post #916062
Posted Wednesday, May 5, 2010 8:01 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:26 AM
Points: 2,840, Visits: 3,963
middletree (5/4/2010)
there's no record of any loginname/password, including sa. And yes, we did try sa and blank.
then how do you login now ?


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #916080
Posted Wednesday, May 5, 2010 8:09 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 9, 2010 7:58 PM
Points: 121, Visits: 195
I can't log in. I know the DB exists, but can't get in.
Post #916093
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse