When trying to access the Database Management tools you get the following Message, Unable to detect the SQL Agent service. Please ensure that the SQL Agent service is installed and is enabled
The MessageStats service account is not a sysadmin on the SQL server that hosts the MessageStats database.
or
The SQL Server Agent Service is not running on the SQL Server.
or
You are not logged into the MessageStats server as the MessageStats service account.
Follow the steps below to add the sysadmin server role to the MessageStats service account.
1. Open SQL Server Management Studio and connect to the server that hosts the MessageStats database.
2. Expand the Security Tab then Logins
3. Right click on the MessageStats service account and select properties
4. Click on the Server Roles Tab on the Right hand pane.
5. Check off the sysadmin role and click OK
or
Start the SQL Server Agent service , it needs to be set to Automatic and started.
*Keep in mind that the MessageStats service account should have admin rights and you need to be logged into the MessageStats server as the MessageStats Service account as SQL uses the logged on credentials"
