SQL Server 2000 LOST SA PASSWORD

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

UselessUser - 18 Jul 2008 13:30 GMT

Hi,

As above really. We have one application which uses SQL Server 2000 as a
backend. The people who used to maintain it left a long time ago, and I need
to configure BackupExec to backup the database but I do not have the SA
password. The local administrators group has been taken out of the security
sections so I cannot do that either...

I have heard that the only way around this is to uninstall SQL Server
completely, then reinstall it using a new SA password which I know (And will
document) and then reattach the database?

The problem is I know very little about SQL Server and am not sure how the
SA login equates to the database (Is it stored in the master table etc?) and
how to restore everything back to working order...

The application we are using is Goldmine. I believe each user created in
Goldmine has a profile which in turn uses a specific Goldmine account?

Reply to this Message

David Hay - 18 Jul 2008 14:36 GMT

A couple ideas

1: If you have anotyher accounts that has sysadmin privilages in
SQL. You can change the SA password from that account.

or

2: Follow the instructions from the following post on lazydba. I
have not done this, but in theory it should work! Note that it will
require bouncing the database a couple times.

http://www.lazydba.com/sql/1__7395.html

Good luck!

David Hay

Reply to this Message