| Author |
 Topic  |
|
|
Takim
Starting Member
Spain
2 Posts |
 Posted - 08/16/2012 : 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
Flowing Fount of Yak Knowledge
United Kingdom
1770 Posts |
Posted - 08/16/2012 : 15:13:14
|
Is there any adminsitrator - who could reset the password?
Jack Vamvas
--------------------
http://www.sqlserver-dba.com |
 |
|
|
Takim
Starting Member
Spain
2 Posts |
Posted - 08/18/2012 : 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
Flowing Fount of Yak Knowledge
United Kingdom
1770 Posts |
Posted - 08/18/2012 : 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 |
|
|
|
jardrake
Starting Member
3 Posts |
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1770 Posts |
Posted - 08/20/2012 : 01:34:38
|
Takim , did you check the BUILTIN\Administrators option?
Jack Vamvas
--------------------
http://www.sqlserver-dba.com |
|
|
|
chadmat
The Chadinator
USA
1958 Posts |
Posted - 08/20/2012 : 02:19:48
|
Worst case, stop SQL, copy your DB files (MDF and LDF) reinstalll SQL, and Attach.
-Chad |
|
|
| |
Topic |
|
Password forgotten
