Solved

Recover the password of the sql user?

Posted on 2014-09-25
9
213 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
ID: 40344476
You can only reset it, not recover it.
0
 
LVL 7

Expert Comment

by:Pushpakumara Mahagamage
ID: 40344508
Ray is correct, reset the password.
0
 

Author Comment

by:Rocking
ID: 40345250
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
ID: 40345298
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 14

Expert Comment

by:Vikas Garg
ID: 40345562
Hello,

Login with Windows authentication

Click on Login => SA=> Right click Properties

And enter new password

That's it
0
 

Author Comment

by:Rocking
ID: 40347715
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
ID: 40348115
'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
ID: 40348218
how to check permissions in have logged in with windows authentication
0
 
LVL 75

Accepted Solution

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Add total to a tablix with ReportItem values 15 42
recover sqlserver db 8 57
SQL VIEW 7 24
Trouble analysing a database 9 15
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

863 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

20 Experts available now in Live!

Get 1:1 Help Now