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

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

Is it possible to upgrade the database without the sa login (and noone
else belonging to admin group)?
Helmut Woess wrote:
> 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