Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: 128, 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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 11:52 AM
Points: 1,733, Visits: 3,353
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: 128, Visits: 195
Sorry I should have mentioned I tried that.
Post #915694
Posted Tuesday, May 4, 2010 3:27 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 11:52 AM
Points: 1,733, Visits: 3,353
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: Wednesday, November 30, 2016 12:32 PM
Points: 4,377, Visits: 9,706
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 opportunities 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 @ 8:42 AM
Points: 14,541, Visits: 38,380
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

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
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: Wednesday, November 30, 2016 12:32 PM
Points: 4,377, Visits: 9,706
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 opportunities 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: 128, 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: Tuesday, July 19, 2016 4:34 AM
Points: 2,850, Visits: 4,076
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: 128, 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