MS SQL Server - SQL 2000 Service Pack 3a Fails to authenticate

Author

SQL 2000 Service Pack 3a Fails to authenticate

TSparks

2005-09-16, 8:23 pm

I am trying to run service pak 3a against SQL 2000 SP2 and it will not
let me past the authentication stage. It is set to mixed mode and
neither the sa password or mine are accepted. Could there be another
issue stopping me at this point since I should have admin privileges
and I am 99.9% sure the sa password is correct.

I am stumped.

Thanks!

Tom Sparks

Nik Marshall-Blank

2005-09-17, 3:23 am

If there is some doubt as to the SA password create another with SYSADMIN
rights and use that.

--
Nik Marshall-Blank MCSD/MCDBA

"TSparks" <tsparks@gmail.com> wrote in message
news:1126899971.246390.112620@f14g2000cwb.googlegroups.com...
>I am trying to run service pak 3a against SQL 2000 SP2 and it will not
> let me past the authentication stage. It is set to mixed mode and
> neither the sa password or mine are accepted. Could there be another
> issue stopping me at this point since I should have admin privileges
> and I am 99.9% sure the sa password is correct.
>
> I am stumped.
>
>
> Thanks!
>
> Tom Sparks
>

Sponsored Links