SQL agent unable to run jobs. -
07-06-2003
, 01:51 PM
I've got a freshly installed SQL2000 with SP3a, on windows 2000 SP4. It is
in close proximity to the web, so it has been partially hardened, according
to MS's instructions ni "Improving Web Application Security".
Everything runs fine, except SQL agent is not able to run jobs.
When we run a job from the enterprise manager, we get the following message
on the screen: Microsoft SQL-DMO (ODBC SQLState 42000) Error 22022:
SQLServerAgent is not currently runing so it cannot be notified of this
action. However: SQL agent IS running.
The event log shows the following:
- Event ID 17052, Source MSSQLSERVER: You do not have sufficient operating
system permission to open the SQLServerAgent status event.
- Event ID 322, Souce SQLSERVERAGENT: The data portion of event 17052 from
MSSQLSERVER is invalid.
SQLserver is started with a low permission account, while SQLserver Agent
starts with a different login, with local administrative rights. Both
accounts have sysadmin permissions in SQL. The server only accepts TCP/IP
connections.
It's either a permission problem or a port/network/protocol problem, but I
cannot figure it out.
Any help greatly appreciated.
Thanks.
denis (AT) wwstar (DOT) com |