Problems with the SA password

[forostec]

Hello, we have some problems because some malicious user change the SA password from my SQL Server 2000, how can i restore it or fix this problem?

Thanks for the help.

 

[Pbjmam]

forostec,

I belive if you logon to the server with an id that has local admin rights, you should be able to go into Enterprise manger and reset the password.

pbjmam

 

[SQLBill]

Yes, you do have problems....how did an unauthorized user change the SA password? Was it a blank password?

As pbjmam says, you should be able to log on with an account that has admin rights on the computer and make the change.

-SQLBill

 

[Madsworld]

Just a followup question. What if you are having problems finding the Enterprise manger?

 

[SQLBill]

Madsworld,

How is this a followup question? It has nothing to do with what pbjmam has posted. But....

Maybe it's not installed???

First try this:
Go to Start>Programs>Microsoft SQL Server and see if Enterprise Manager is listed there.

If it's not there - it's not installed. Run the install disk and install the client tools.

You should have started your own thread about this.

-SQLBill

Posting advice: FAQ481-4875