Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Forgot Sql server password Expand / Collapse
Author
Message
Posted Tuesday, November 24, 2009 11:37 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 8, 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
Posted Wednesday, November 25, 2009 12:16 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:01 AM
Points: 11,194, Visits: 11,165
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
Posted Wednesday, November 25, 2009 1:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 8, 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
Posted Wednesday, November 25, 2009 1:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, November 25, 2009 4:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 8, 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
Posted Wednesday, November 25, 2009 7:30 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:39 PM
Points: 42,953, Visits: 36,110
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
Posted Wednesday, November 25, 2009 9:05 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 8, 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
Posted Wednesday, November 25, 2009 10:39 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:39 PM
Points: 42,953, Visits: 36,110
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
Posted Tuesday, December 29, 2009 1:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, August 16, 2010 7:20 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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 »

Add to briefcase 12»»

Permissions Expand / Collapse