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
 General SQL Server Forums
 New to SQL Server Programming
 Password forgotten

Author  Topic 

Takim
Starting Member

2 Posts

Posted - 2012-08-16 : 12:10:33
Hi everyone,
Could some one help me recuperate the password I put to my database?

More than 5 months without working on my sql query browser and no way to access to the database without the password.

Many thanks in advance,
Best regards,
Takim

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-08-16 : 15:13:14
Is there any adminsitrator - who could reset the password?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

Takim
Starting Member

2 Posts

Posted - 2012-08-18 : 10:43:03
Hi Vamvas,

I have installed a version in my machine. I my self set the password but forgot it. Could it be possible to recuperate it or to open the database without using it and how?

Many thanks in advance,
Best regards,
Driss
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-08-18 : 12:08:57
This is a long shot - but , if there is a SQL Server Security logon called BUILTIN\Administrators, which you have added or added automatically depending on the SQL Server Version, then try to logon using Windows Authentication. Your current logon would need to be part of the Local Administrators of the computer itselg

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

jardrake
Starting Member

3 Posts

Posted - 2012-08-19 : 15:34:39
You really have to get an administrator to do it. But if you are it, you might have to rebuild the database. :(

I am a writer for the SQL Tutorial and Reference (http://www.afterhoursprogramming.com/index.php?content=SQL-Overview&article=167) section of afterhoursprogramming.com
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-08-20 : 01:34:38
Takim , did you check the BUILTIN\Administrators option?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

chadmat
The Chadinator

1974 Posts

Posted - 2012-08-20 : 02:19:48
Worst case, stop SQL, copy your DB files (MDF and LDF) reinstalll SQL, and Attach.

-Chad
Go to Top of Page

sunnycolund
Starting Member

1 Post

Posted - 2013-08-13 : 22:38:46
There are many ways to reset lost Windows passwords, but I think the best and easiest way to reset Windows password is to use the Windows password recovery software. Here is the solution of unspammed
Go to Top of Page
   

- Advertisement -