mickgreen58
asked on
SQL Server 2000 Agent
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. [298] SQLServer Error: 1115, Cannot generate SSPI context [SQLSTATE HY000]
2. [382] Logon to server '(local)' failed (SaveAllSchedules)
Specs
Windows 2000 Server
SQL Server 2000
- Mike G.
1. SQL Server. [298] SQLServer Error: 1115, Cannot generate SSPI context [SQLSTATE HY000]
2. [382] Logon to server '(local)' failed (SaveAllSchedules)
Specs
Windows 2000 Server
SQL Server 2000
- Mike G.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Okay, let me get back to some basics here as I think you all are touching on somethings that may be the problem.
Okay, lets say my username is MikeG on Windows when I log onto the computer.
Okay, think about SQL Query Analyzer now. When I log onto SQL Query Analyzer as "Windows Authentication", what user name is SQL Server using? Is it MikeG the Windows account I logged in under?
I ask this as the Windows Authentication works fine and well, but MikeG is not a user in the SQL Server Database. Which can be tied into what I saw in Services. It has "Log on as Local Systems Account". So what is the Local Systems Account? Also, the start up was listed as Manual, which could be a problem too.
- Mike G.
Okay, lets say my username is MikeG on Windows when I log onto the computer.
Okay, think about SQL Query Analyzer now. When I log onto SQL Query Analyzer as "Windows Authentication", what user name is SQL Server using? Is it MikeG the Windows account I logged in under?
I ask this as the Windows Authentication works fine and well, but MikeG is not a user in the SQL Server Database. Which can be tied into what I saw in Services. It has "Log on as Local Systems Account". So what is the Local Systems Account? Also, the start up was listed as Manual, which could be a problem too.
- Mike G.
"When I log onto SQL Query Analyzer as "Windows Authentication", what user name is SQL Server using? Is it MikeG the Windows account I logged in under?"
YES Your active login info would be used - MikeG
"It has "Log on as Local Systems Account" this is fine but it definitely needs to auto start.
YES Your active login info would be used - MikeG
"It has "Log on as Local Systems Account" this is fine but it definitely needs to auto start.
ASKER
I just restarted the CPU and the Agent was started. I will have to wait to see if the process run without it stopping and then award points.
Paul