Forgot Sql server password

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Forgot Sql server password

11 posts, Page 1 of 2

1 2 »»

Forgot Sql server password

Rate Topic

Display Mode

Topic Options

Author

Message

Jack_Thiru from chennai

Posted Tuesday, November 24, 2009 11:37 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, April 08, 2011 5:38 AM
Points: 4, 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

Post #824316

Paul White

Posted Wednesday, November 25, 2009 12:16 AM

SSChampion

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 10:33 AM
Points: 10,989, Visits: 10,529

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
SQL Server MVP
SQLblog.com
@SQL_Kiwi

Post #824328

Jack_Thiru from chennai

Posted Wednesday, November 25, 2009 1:38 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, April 08, 2011 5:38 AM
Points: 4, Visits: 15

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

Thanks
Thiru

Post #824362

murgocimark

Posted Wednesday, November 25, 2009 1:48 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, July 20, 2012 2:49 AM
Points: 6, Visits: 69

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

Post #824365

Jack_Thiru from chennai

Posted Wednesday, November 25, 2009 4:39 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, April 08, 2011 5:38 AM
Points: 4, 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

Post #824424

GilaMonster

Posted Wednesday, November 25, 2009 7:30 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:59 PM
Points: 37,640, Visits: 29,895

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 2008, MVP
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

Post #824539

Jack_Thiru from chennai

Posted Wednesday, November 25, 2009 9:05 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, April 08, 2011 5:38 AM
Points: 4, 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

Post #825030

GilaMonster

Posted Wednesday, November 25, 2009 10:39 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:59 PM
Points: 37,640, Visits: 29,895

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 2008, MVP
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

Post #825048

dreamupup

Posted Tuesday, December 29, 2009 1:21 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 30, 2009 8:48 PM
Points: 1, 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.

Post #839728

yitiana

Posted Monday, August 16, 2010 7:20 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, September 24, 2010 11:51 PM
Points: 10, 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.

Post #970103

« Prev Topic | Next Topic »

11 posts, Page 1 of 2

1 2 »»

Permissions