fred2k3
asked on
Get SQL 200 SA Password
I am running microsoft sql 2000 std edition. I have had to perform a DR and need to start the SQL server. The SQL server wont run unless i change the SQL registration properties from 'Use SQL Server Authentication' to 'Windows Authentication'. I need to change this back after the DR to ensure that the applications on the machine still work. How can i retrieve the sa password to do this?
Thanks
Thanks
ASKER
Thanks, what password recovery tool should i use? I dont have any experience with these.
You shouldn't need the sa password, just log in as a Local Administrator, and you should have sysadmin rights there. Then you can set the sa password as required.
Rob
Rob
yes, Rob is right. Don't need password recovery software as it is not give you 100% guarantee for recovery. you can login with any user in windows authentication or SQL authentication which has rights of SysAdmin fixed server role, and reset password of SA. if you don't know any user with SysAdmin role in your server than you are out of luck.
ASKER
So what does the registration details of the Enterprise SQL represent? Does it not have anything to do with applications using the sa password?
Thanks again
Thanks again
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks guys
Something else is going on if the service does not start. The authentication mode of the sql server does not prevent it from starting.
Double check that the credentials under which you are starting the SQL services have the requisite rights depending on your setup. Do the credentials have administrative rights? If your SQL 2000 setup uses AWE and the credentials do not have administrative rights, you have to grant the user the ability to lock pages in memory among other rights.
The quick method is add the user to the administrators group and see whether that gets the service running. You should make sure to explicitly specify the requisite rights to the user before removing the user from the administrators group.
I do not belive there is a way to alter the authentication mode in SQL 2000 while the sql service is not running as available in sql 2005 through the sql server configuration tool.