Link to home
Start Free TrialLog in
Avatar of mickgreen58
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.

Avatar of PaulBarbin
PaulBarbin

Check under SQL Server Agent (in Enterprise Manager) Properties.  Under the connection tab, how is the agent logging in?  Check password or rights.

Paul
ASKER CERTIFIED SOLUTION
Avatar of Mike_V
Mike_V
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mickgreen58

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.
"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.
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.