Solved

Recover the password of the sql user?

Posted on 2014-09-25
9
211 Views
Last Modified: 2014-10-02
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
Comment
Question by:Rocking
  • 3
  • 2
  • 2
  • +2
9 Comments
 
LVL 10

Assisted Solution

by:Ray
Ray earned 333 total points
Comment Utility
You can only reset it, not recover it.
0
 
LVL 7

Expert Comment

by:Pushpakumara Mahagamage
Comment Utility
Ray is correct, reset the password.
0
 

Author Comment

by:Rocking
Comment Utility
can u pls provide the query to reset the password?
Is it possible to reset the password from sql server client?
0
 
LVL 10

Assisted Solution

by:Ray
Ray earned 333 total points
Comment Utility
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 14

Expert Comment

by:Vikas Garg
Comment Utility
Hello,

Login with Windows authentication

Click on Login => SA=> Right click Properties

And enter new password

That's it
0
 

Author Comment

by:Rocking
Comment Utility
when i try to change the password it says

'test' is not a valid login or you do not have permission.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
Comment Utility
'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
 

Author Comment

by:Rocking
Comment Utility
how to check permissions in have logged in with windows authentication
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 167 total points
Comment Utility
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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now