SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Password forgotten
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Takim
Starting Member

Spain
2 Posts

Posted - 08/16/2012 :  12:10:33  Show Profile  Reply with Quote
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
1911 Posts

Posted - 08/16/2012 :  15:13:14  Show Profile  Visit jackv's Homepage  Reply with Quote
Is there any adminsitrator - who could reset the password?

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

Takim
Starting Member

Spain
2 Posts

Posted - 08/18/2012 :  10:43:03  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
1911 Posts

Posted - 08/18/2012 :  12:08:57  Show Profile  Visit jackv's Homepage  Reply with Quote
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 - 08/19/2012 :  15:34:39  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
1911 Posts

Posted - 08/20/2012 :  01:34:38  Show Profile  Visit jackv's Homepage  Reply with Quote
Takim , did you check the BUILTIN\Administrators option?

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

chadmat
The Chadinator

USA
1974 Posts

Posted - 08/20/2012 :  02:19:48  Show Profile  Visit chadmat's Homepage  Reply with Quote
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 Posts

Posted - 08/13/2013 :  22:38:46  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000