Have just now joined the forum, with a perplexing problem.
The SQL Server Agent doesn't start on my SQL Server!
Or rather it's giving me a mixed response.
In control panel > services, it says 'Started' and is set to 'automatic'.
But in the Enterprise Manager's > Management it shows SQL SErver Agent as not started (red). When I right click to manually start it, it gives me error 1056: An instance of the service is already running.