Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 254
  • Last Modified:

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?
0
Rocking
Asked:
Rocking
  • 3
  • 2
  • 2
  • +2
3 Solutions
 
RayData AnalystCommented:
You can only reset it, not recover it.
0
 
Pushpakumara MahagamageVPCommented:
Ray is correct, reset the password.
0
 
RockingAuthor Commented:
can u pls provide the query to reset the password?
Is it possible to reset the password from sql server client?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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
 
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now