I am having problems with my SQL Server Agent. I have it running a Database Maintenance Plan that just backs up the Systems DBs and User DBs at 6 PM every day and it also runs a DTS Package that just copies DB Objects from my Web Host Provider's Website to my local SQL Server. Everytime I go in there, the SQL Server Agent has stopped and the following errors are in there:
1. SQL Server.  SQLServer Error: 1115, Cannot generate SSPI context [SQLSTATE HY000]
2.  Logon to server '(local)' failed (SaveAllSchedules)
Windows 2000 Server
SQL Server 2000
- Mike G.