View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 06:15 PM
Frank Py
 
Posts: n/a
Default Can't Auto-Start Agent

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!
Reply With Quote