|
|
Posted by eddie on 09/25/06 08:12
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
Navigation:
[Reply to this message]
|