Forgot Sql server password

Question

Forgot Sql server password

Jack_Thiru from chennai

Valued Member

Points: 52
More actions
November 24, 2009 at 11:37 pm

#143115

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

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Paul White SSC Guru Points: 150467 More actions · Answer 1

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
SQLkiwi blog
@SQL_Kiwi

Jack_Thiru from chennai Valued Member Points: 52 More actions · Answer 2

thank you very much.

could you please explain steps to reset password or how to reset password using management studio.??

Thanks

Thiru

murgocimark Valued Member Points: 68 More actions · Answer 3

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 Valued Member Points: 52 More actions · Answer 4

🙂 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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

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 Valued Member Points: 52 More actions · Answer 6

🙂 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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

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 Newbie Points: 9 More actions · Answer 8

I used MS SQL Server Password Unlocker to reset SQL password[/url] 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 SSC-Addicted Points: 478 More actions · Answer 9

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.

duocaiduoyi2009 SSC Enthusiast Points: 139 More actions · Answer 10

Why not try SQL password recovery?

I experienced it last month, it is really nice.

james.mascarenhas07 Grasshopper Points: 15 More actions · Answer 11

Option 1:- Change SQL Server Password in Management Studio

Option 2:- Change SQL Server Password using SQL Script

Option 3:- Change SQL Server Password with software (No technical expertise required)

Since the first two options are already elaborated extensively I restrict myself for the option 3 only. A user with little or no technical knowledge of SQL Database can easily perform the resetting of SQL password without have to worry about data loss. The software is designed keeping simplicity in mind and therefore is a perfect companion for every System Administrator. Extensive knowledge and software description can be gained through the official website. http://www.mssqlserverrecovery.net/sql-password-recovery

emily_glatt Grasshopper Points: 11 More actions · Answer 12

The single user mode is less known to SQL Server users. After password forgotten, just start your SQL Server instance in single user mode and it allows you to run the SQLCMD command to reset your login password, or create a new user account. Check out this how-to article for detailed instructions.

Elliswhite SSCommitted Points: 1783 More actions · Answer 13

Using Windows authentication mode you can easily login in SQL Server database:cool:

SSMS Expert