SA Password Recovery - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

SA Password Recovery

Author

Topic

anarayanamoorthy
Starting Member

15 Posts

Posted - 2011-02-04 : 01:23:29

Hi,

I want to recover the password for SA. As the DBA is not inplace and I don't have sysadmin rights for any other database users with which I can go ahead and change the password for SA. How can I can recover the password for SA.

Narayanamoorthy A

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-02-04 : 03:15:24

So you're basically asking how you can hack a database you don't have access to...??

- Lumbago
My blog-> www.thefirstsql.com

anarayanamoorthy
Starting Member

15 Posts

Posted - 2011-02-04 : 05:21:18

Hi Lumbago,

No not at all. I am the dba and want access to all the database for running queries.

Narayanamoorthy A

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-02-04 : 05:40:33

Well...as far as I know there is no way of recovering the SA password, and if there was I sure as he** wouldn't post it here. Can you log in to the server at all? Are you able to run this query somehow ->

SELECT loginname
FROM master.dbo.syslogins
WHERE sysadmin = 1 AND isntgroup = 0

It will list all the sysadmins in the database...if you know the owners of either of them they might be able to help you.

- Lumbago
My blog-> www.thefirstsql.com

MIK_2008
Master Smack Fu Yak Hacker

1054 Posts

Posted - 2011-02-04 : 05:45:49

if you failed all ways then re-install the sql server .. at least you will get your own SA account :D

cheers!
MIK

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-02-04 : 08:13:42

MIK, that's like swatting a fly with a sledgehammer. You don't reinstall SQL because you lost the sa password. You log in with an admin windows account (in 99% of cases). Plus, if you don't have enough authority to reset the sa password, then you don't have enough to install SQL Server anyway (but that is beside the point).

And what of the data? Just throw it away? Because you probably don't have enough authority to backup or restore either at this point...

In most well thought out schemes, nobody needs to know the sa password anyway.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources