SQL Agent question -- sql server (alternate)

Wangkhar NO[at]SPAM yahoo.com
2/27/2004 3:34:12 AM

Dumb question perhaps, but hey.

SQL Agent on sql2k, client sp3a, server vanilla.
In EM Agent Icon Status does'nt show. Server running status doesnt
show till explicitly connected.
Agent has both start and stop menu options enabled, and no green
arrow/red square (Green Arrow, Red Square ... sounds like a Russian
kung fu flick). Also if I try to start it I get error 5 - access
denied. Believe it is running tho - jobs happily ticking over.

?

Simon Hayes
2/27/2004 6:42:30 PM

[quoted text, click to view]

EM uses operating system permissions to get service information, so it may
be that you don't have sufficient permissions at the OS level.
Alternatively, the server may be behind a firewall which is blocking the
ports used to connect to Windows.

Simon

sql server (alternate) : SQL Agent question