Re: sa password lost



Hi
Ask someone who is admin:-)) I'm affraid you cannot.


"sysbox27" <sysbox27@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:15C050C0-F5C3-4CD4-B58D-949093ABFF29@xxxxxxxxxxxxxxxx
Hi,
If the sa password has been lost, and I login in as a local admin on the
host server and then use nt authentication to connect to sql server 2000
that
works.
However I now don't have any rights to do anything as apparantly not part
of
sysadmin group and therefore can't reset sa password. How do I go about
assigning sysadmin rights and then changing sa password.
Thanks in advance for any help.



.