Frank Py <fpy@proactnet.com> wrote in message news:<3f843998$0$202$75868355@news.frii.net>...
> I have a SQL Server 2000 that failed to start after a Windows reboot.
> Agent properties are checked to auto start if stopped. Under the Agent
> Error Log, I have the following data:
>
> Information:
> SQL Agent stopping because of Windows shutdown.
> SQL Agent terminated normally.
>
> Error:
> SQL Server Error: 1115, cannot generate SSPI context SQLState HY000.
> Logon to server(local) failed.
>
> Help apprecaited. Thanks
> Frank
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

You might find these KB articles helpful:

http://support.microsoft.com/default...&Product=sql2k
http://support.microsoft.com/default...&Product=sql2k

Simon