Recover the password of the sql user?

hi experts,

How can i recover the password of the sql user?
I have saved the password in the sqlserver client vault,now i am able to connect to the server through client i can connect?
I can't remember the saved password? Is there any way in which i can recover the saved passoword?
RockingAsked:
Who is Participating?
 
Anthony PerkinsCommented:
Requires at least ALTER ANY LOGIN permission and if the login is a member of sysadmin server role you will require CONTROL SERVER permission.
0
 
RayData AnalystCommented:
You can only reset it, not recover it.
0
 
Pushpakumara MahagamageVPCommented:
Ray is correct, reset the password.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
RockingAuthor Commented:
can u pls provide the query to reset the password?
Is it possible to reset the password from sql server client?
0
 
RayData AnalystCommented:
You can follow these instructions and replace "SA" with your username. This assumes you do know a valid set of credentials.

http://blog.sqlauthority.com/2007/12/29/sql-server-change-password-of-sa-login-using-management-studio/
0
 
Vikas GargBusiness Intelligence DeveloperCommented:
Hello,

Login with Windows authentication

Click on Login => SA=> Right click Properties

And enter new password

That's it
0
 
RockingAuthor Commented:
when i try to change the password it says

'test' is not a valid login or you do not have permission.
0
 
Anthony PerkinsCommented:
'test' is not a valid login or you do not have permission.
So it test a valid login?  Do you have the appropriate permissions?
0
 
RockingAuthor Commented:
how to check permissions in have logged in with windows authentication
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.