Re: sa password lost
- From: "Uri Dimant" <urid@xxxxxxxxxxx>
- Date: Mon, 13 Aug 2007 17:16:43 +0300
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.
.
- Prev by Date: Re: Run SQL T-SQL Job Step across Different Domains
- Next by Date: Re: SQL DB with legacy Access Frontend - How do we stop people getting in through the backdoor?
- Previous by thread: Re: Run SQL T-SQL Job Step across Different Domains
- Next by thread: Re: Users , Web Application and SQL Server back end - Beginner Questio
- Index(es):