dbTalk Databases Forums  

SQL agent unable to run jobs.

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup


Discuss SQL agent unable to run jobs. in the microsoft.public.sqlserver.setup forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Denis Caron
 
Posts: n/a

Default 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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.