SSMS - SQL Server Agent icon with red x.
-
In SSMS, I noticed one of my SQL Server instances (I believe SQL Server 2000) there was a red x with the SQL Server Agent icon. I went to the server and checked the following:
Services - it showed the agent was started
Log file - "SQLSERVERAGENT starting under Windows NT service control"
Event viewer - did not really show anything compelling.
Any thoughts on what could be causing this? Any comments / URLs would be appreciated.
Thank you.
-
If you restart the SQL Server Agent service, there will always be something in the event viewer marked as an error. It can be a failure to authenticate the account under which the service is running, missing files, disk permissions, etc.
Check the Windows event viewer log carefully.
-
bobba (2/17/2012)
In SSMS, I noticed one of my SQL Server instances (I believe SQL Server 2000) there was a red x with the SQL Server Agent icon. I went to the server and checked the following:Services - it showed the agent was started
Log file - "SQLSERVERAGENT starting under Windows NT service control"
Event viewer - did not really show anything compelling.
Any thoughts on what could be causing this? Any comments / URLs would be appreciated.
Thank you.
CAn you first check if the server is really a SQL 2000 Server? Can you tell me what happends when you right click on the agent and select start?
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply