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.
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 |
|
|
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 |
|
|
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 itselgJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
|
|
|
|
|