Posted by Helmut Woess on 09/25/06 06:59

Am 24 Sep 2006 14:10:15 -0700 schrieb eddie:

> Hi Guys,
> We've lost the password for the sa. No other users belong to the admin
> group. I've tried logging in using osql -E (windows authentication)
> without success. Is there anyway to reset the sa password? The database
> is MSDE and the version seems to be 7 (sql server 7 folder on pc). It
> is running on Windows 2000 professional.Any help would be greatly
> appreciated.
> Regards,
> Eddie

AFAIK since SQL 7 you have authentication and it is not possible to disable
login per windows authentication. So if you are logged in as windows admin
you should always be able to connect to a database like "master" (if the
server is running :-)) ). Then you can use sp_password for setting a new
password for sa.
Or you stop the server, save your database-/logfiles, make a new install of
SQL Server and then attach your database files again.

bye, Helmut

• Next in forum: Re: reset sa password msde (sql server 7)
• Prev in forum: what should i do when i want to save a select resultset,but not in a new table,in memory is the best?
• Thread view: Re: reset sa password msde (sql server 7)

[Reply to this message]