SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Forgot Sql server password


Forgot Sql server password

Author
Message
Jack_Thiru from chennai
Jack_Thiru from chennai
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 15
Hi,

How to reset sql server 2005 password. I can able to login using windows authentication, is there any way to recover or reset my password from windows authentication...

Thanks
Thiru
Paul White
Paul White
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15830 Visits: 11355
If your Windows Authentication account has the appropriate permissions, you can use any of the usual methods, including Management Studio and ALTER LOGIN



Paul White
SQLPerformance.com
SQLblog.com
@SQL_Kiwi
Jack_Thiru from chennai
Jack_Thiru from chennai
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 15
thank you very much.
could you please explain steps to reset password or how to reset password using management studio.??

Thanks
Thiru
murgocimark
murgocimark
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 76
Hi,
with Management Studio, connect to your SQL Server with Windows authentication,
In Object Explorer panel go to Security->Logins, expand this and right click on sa user...
there you can set your password again
Jack_Thiru from chennai
Jack_Thiru from chennai
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 15
:-) Thanks alot.
I got it now. I reset my password successfully...

Question number 2:
================
If i forgot my user as well as password how do we find users in the sql servers using windows aunthentications, if we can find then we can easiy reset passwords, in this way we can reset all passwords am i correct.

If this is correct then security is not there for passwords, if i know a user i can directly login using windows authentication and reset passwords as such...
How can we protect passwords from this kind of resets?

Thanks
Thiru
GilaMonster
GilaMonster
SSC Guru
SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)

Group: General Forum Members
Points: 87889 Visits: 45274
Jack_Thiru from chennai (11/25/2009)
If this is correct then security is not there for passwords, if i know a user i can directly login using windows authentication and reset passwords as such...


They can only log in if their windows account has access to the SQL Server. They can only reset passwords if they have sufficient permission. Members of the sysadmin group can reset all passwords. Members of the securityadmin group can reset passwords (though iirc they cannot reset a sysadmin's password)
Anyone granted the ALTER permission on a login can change that login's password.
Logins can change their own passwords

How can we protect passwords from this kind of resets?

Make sure that the only people with the required level of permissions are the ones that are allowed to reset passwords.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Jack_Thiru from chennai
Jack_Thiru from chennai
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 15
:-) Thanks gila! thanks every one. I got it now.. user who have alter permissions can change passwords!..

Hi,

If you give one simple and sample example for ALTER users. it will be help every one who looks for a solution for this kind of problem..

Thanks
Thiru
GilaMonster
GilaMonster
SSC Guru
SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)

Group: General Forum Members
Points: 87889 Visits: 45274
Jack_Thiru from chennai (11/25/2009)
If you give one simple and sample example for ALTER users. it will be help every one who looks for a solution for this kind of problem..


If you do a quick google search, you'll easily come up with more than one simple and sample example

http://www.google.com/search?q=ALTER+LOGIN+site%3Amsdn.microsoft.com
http://msdn.microsoft.com/en-us/library/ms189828.aspx (SQL 2008, has a link to the 2005 one)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


dreamupup
dreamupup
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 1
I used MS SQL Server Password Unlocker to reset SQL password when I forgot the MS SQL password a few days ago. I took two days to find a capable solutions but arrive no result. Fortunately, one of my class mates recommended me to reset the sql password with MS SQL Server Password Unlocker ; it is fast and easy to use, but no data loss.
yitiana
yitiana
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
Points: 24 Visits: 34
You can use command prompt to change sql password.
Osql -S yourservername -E 
1> EXEC sp_password NULL, 'yourpassword', 'sa'
2> GO


Here is an article describes 4 methods to change sql server password, that could help.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search