i forgot password of my sql2005 user

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

I have created a new user in my Sql-2005 , now the problem is that i dont remember password for the user. and i want to recover the password or reset it .. plz help me

user: pradeep
password: i forgot password..

Posted 25-Apr-11 7:45am

Member 7849016

Add a Solution

Comments

Smithers-Jones 25-Apr-11 13:57pm

Surely you have written it down on a PostIt-note and stuck it on your screen? :-)

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tarun.K.S · Answer 1 · 2011-04-25T08:05:00

Solution 1

Try these links :

http://www.programmersheaven.com/user/sqlpasswordrec/blog/[^]

http://worthposting.wordpress.com/2008/11/01/sql-server-reset-sa-password/[^]

or google this : recover sql server password 2005[^]

Next time do what Smithers-Jones said! ;)

Posted 25-Apr-11 8:05am

Tarun.K.S

Updated 25-Apr-11 8:07am

v2

Comments

Sergey Alexandrovich Kryukov 25-Apr-11 14:12pm

I don't understand: do you mean to say that password is recoverable (not resettable but recoverable)?! If it is so, it would majorly defeat the purpose of password.
--SA

Tarun.K.S 25-Apr-11 14:19pm

I thought those links might help him recover in some way or the other. OP could also try the "Windows Authentication" mode instead of the "user-name" and password mode.

Tarun.K.S 25-Apr-11 14:22pm

If not recover, he might have to create a new user then.

Sergey Alexandrovich Kryukov 25-Apr-11 14:51pm

That would be right thing, or one of them. I'm still not sure if recovery of the password is possible. Do you know the answer?
--SA

Tarun.K.S 25-Apr-11 15:01pm

It depends upon PC. I use Windows 7 and on using Windows Authentication mode, it didn't allow me to login. I started searching Google on the exception I got and finally did it. You have to "run it as administrator" and then login(I searched google for the solution) and then grant privileges to it by opening the Security\Logins in the Object Explorer of the Sql Server Management Studio. So now its working fine but its a tad tedious job and it freaked me out!
Google will help him for sure.

Sergey Alexandrovich Kryukov 25-Apr-11 16:39pm

OK, it looks like retrieval of the password (old password, not re-setting it) is impossible, which would be a right thing. Did I understand it right. I would never trust my password to a system which would allow to restore in breaking one-way nature of encryption.
I voted 5 after all, but I'm not sure I understand it all so far.
--SA

Tarun.K.S 26-Apr-11 2:28am

I think you are right. If not retrieval, then a new user can be an option as the database won't be affected. However, the new user should be granted certain privileges like Creating and Altering tables which I think should be done using an Administrator account. Let's see if OP resolved it or not.
Thanks for the 5!

Sergey Alexandrovich Kryukov 26-Apr-11 11:29am

Sure. Thank you for the discussion.
--SA