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»»

SA Password Expand / Collapse
Author
Message
Posted Thursday, February 24, 2005 1:03 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, October 07, 2013 4:37 AM
Points: 256, Visits: 224
Hi all, is there any one who can help me in recovering my SA password. I m in deep trouble, is there any way by which i can recover my sa password. Currently i have not any other user with sys admin, security admin rights.
Post #163874
Posted Thursday, February 24, 2005 7:40 PM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, March 30, 2005 11:53 AM
Points: 15, Visits: 1
Didn't you write it down in a safe place??


Kindest Regards,

Jon
Free Cell Phone Games
Post #163947
Posted Friday, February 25, 2005 1:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 06, 2014 8:23 PM
Points: 195, Visits: 149

Are you using integrated security or standard. I am assuming standard. If so then change the security mode to mixed (this can be done via the registry - it has been posted before). Make sure you are in the admins group and then you can change the sa password.




Post #163976
Posted Friday, February 25, 2005 1:43 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 01, 2011 5:42 AM
Points: 54, Visits: 18

Jon McMullin - You need to read the rulles before posting unhelpful comments.

People need to know that they can post their problem here without people sneering at them - we've all done silly things, but hopefully we learn by them.

 

Post #163979
Posted Friday, February 25, 2005 5:44 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, February 26, 2014 5:31 AM
Points: 441, Visits: 1,790
Take a look at http://www.ngssoftware.com/sqlcrack.htm


http://glossopian.co.uk/
"I don't know what I don't know."
Post #164030
Posted Friday, February 25, 2005 8:00 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:19 AM
Points: 2,162, Visits: 1,918

In case you can't use the sqlcrack program (I believe you must be sysadmin to run this software) you may need to think about another method.  Do you have access to either EM or QA where via a sysadmin id where the password was saved?  If so you could create yourself an id and change the sa password.

If there really is nothing, you may need to think about reinstalling.  using the latest backups of  the user databases and the msdb database.   This is a fair bit a work, so you may not want to do this without eliminating all other options. 





Francis
Post #164076
Posted Friday, February 25, 2005 8:21 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, June 16, 2006 10:27 AM
Points: 316, Visits: 1

1.  Log in to the OS as administrator.

2.  If yours is a default instance of SQL Server, check the following value to make sure it set to a 0 (if you change this value, you must restart SQL Server):

      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\LoginMode

3.  Run this from the command line to update the 'sa' password to NULL:

      osql -E -Q "EXEC sp_password NULL, NULL, 'sa'"




Post #164087
Posted Friday, February 25, 2005 8:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 11, 2010 12:29 PM
Points: 6, Visits: 3
You can also try this: register the SQL Server in the Enterprise Manager with Windows Authentication. Ensure that the Windows login you are using is a member of the Administrators group of the SQL Server machine. Then you can change the sa password from the EM, by accessing 'Logins' under 'Security'.

Hope this helps.



Post #164092
Posted Friday, February 25, 2005 9:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 18, 2011 10:25 AM
Points: 8, Visits: 49

Here is another procedure

1- Stop MSSQL Server Service

2- Copy all system datafiles to a new folder

3- rebuild your master database, at this point you'll get access to SQL Server with sysadmin rights

4- Start MSSQL Server Service

5- attach old master database, the one backed up on step 2, using the name master_old

6- Execute the foloowing procedure on master_old databases

http://support.microsoft.com/kb/246133/en-usYou

you will get an script with all the logins in the server with the same sid and password ecrypted.

7- Execute The script from step 6.

8- Attach all users databases

9- set the right default database to every single login.

10- set the rights server roles for every single login.

11- detach master_old database

12- stop mssqlserver service and replaces the datafiles for msdb db with the ones backed up in step 2

13- start mssqlserver service

14- check that everything it's ok, and do a full backup, and also store in a secure place the new credentials for sa

Sorry for my poor english and good luck

Francisco Valdebenito

Post #164104
Posted Wednesday, March 02, 2005 9:02 PM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, March 30, 2005 11:53 AM
Points: 15, Visits: 1

You are right . I am sorry for not considering context of how my post would be taken . I was more feeling panic for him not trying to make fun of him . Next time I will be more constructive ! 

These guys sure know how to get to the solution quick! Can you take my full name out of the post please?




Kindest Regards,

Jon
Free Cell Phone Games
Post #165281
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse