Discussion Locked

SQL Server Administrator Password

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have inherited a windows 2000 small business server. No one knows the administrator password for the SQL server. The default user "sa" comes up but the null password does not work. The password for administrator on the windows 2000 server does not work either. Can anyone help?

4 replies

by cg it

the problem is that the SQL SA password does NOT have to be the domain admin password or the local machine password [though SQL recommends using the local admin password to preclude conflicts. It can be whatever the admin specifies it to be.

Passware is the program I recommend. It works every time. Though pricy it's worth the $$.

http://www.lostpassword.com/sql.htm

by flashx10

you can try hacj your server with appliction like
ERD 2005
it will allow you to replace the amin password easly

then you can have full access to the server.

This discussion is closed to new replies.