Yesterday I came across a question in which the user was facing an issue with SQL Server 2008 Agent. The properties of SQL Server Agent could not be opened in SSMS. The following error message was displayed.
Property ErrorLogFile is not available for JobServer '[ServerName]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)
The reasons for this issue can be
- The SQL Server Agent service account does not have access to the SQLServerAgent key in the registry.
- The ErrorLogFile key does not have a value or has a wrong path in the Registry.
The Registry key that is being referred to is located at the following location. This example is from a SQL Server Default Instance.
The Service Account had FULL permissions on this key. In his case the value of ErrorLogFile key was blank.
After entering the correct path in the ErrorLogFile key, the property screen for SQL Server Agent displayed without any errors.