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
fred2k3Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arnoldCommented:
You have to run password recovery tools to get at the data.

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.
0
fred2k3Author Commented:
Thanks, what password recovery tool should i use? I dont have any experience with these.



0
rob_farleyCommented:
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
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

RiteshShahCommented:
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.
0
fred2k3Author Commented:
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
0
RiteshShahCommented:
>>So what does the registration details of the Enterprise SQL represent? Does it not have anything to do with applications using the sa password?<<

don't get you exactly, can you please be more elaborative?
0
arnoldCommented:
http://support.microsoft.com/kb/285097
http://support.microsoft.com/kb/247931

The authentication mode deals with what credentials must be provided to access the database.  using the sa or any other sql login, will provide you access to the database without regard to which mode it is in.  The difference in the mode is that if your server is setup in sql authentication mode, you will not be able to access the resources through integrated windows credentials.

Since you have a DR plan, it is unlikely that your applications are running and using the sa account to access the database.
Once the service is running accessing the enterprise manager while an Administrator or with sysadmin role account, you can change the password set for sa.

not sure why you are concentrating so much at recovering the sa password.

Perform a search for "recover SA password" to locate tools that might help you with that.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rob_farleyCommented:
The Registered Servers is just a list of servers and the credentials you use to log into them, to make life easier for logging in.

It may be that you've connected to some as sa, but if that sa password changes, or is no longer valid, you'll have to find a different way to connect to that same login. You can easily change the details of a registered server.

Hope this helps,

Rob
0
fred2k3Author Commented:
Thanks guys
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.