- 2 minutes to read

FAQ and Troubleshooting guide for the Nodinite Database Monitoring Agent

Unlock the full potential of your database monitoring with the Nodinite Database Monitoring Agent. This guide provides actionable solutions and expert advice for common challenges, ensuring you maintain robust and reliable monitoring.

✅ Ensure secure and correct connection string configuration
✅ Resolve SQL Agent service issues quickly
✅ Access expert support for advanced troubleshooting

Below, you'll find clear solutions to frequently encountered problems and best practices for using the Database Monitoring Agent.

Password with Special Characters

When your password contains special characters such as ; (semicolon), enclose your connection string in single quotes to ensure proper authentication.

Not Working Example

Server=localhost;Database=MSDB;User Id=ServiceAccountName;Password=Da;Password;

Working Example

Server=localhost;Database=MSDB;User Id=ServiceAccountName;Password='Da;Password';

SQL Agent is Stopped or Disabled

If the SQL Agent service is not running, Monitor Views with the Nodinite Database Monitoring Agent will display a Resource error message:
SQL Agent Disabled
Example error message for a stopped or disabled SQL Server Agent

The following LogText (in English) may appear, depending on your SQL Server language settings:

SQL Server blocked access to procedure 'sys.xp_sqlagent_enum_jobs' of component 'Agent XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For more information about enabling 'Agent XPs', search for 'Agent XPs' in SQL Server Books Online.

To resolve this issue, you have two options:

  • Start the SQL Agent Windows Service for the relevant SQL Server instance using Microsoft Services MMC (Recommended).
    Start SQL Server Agent
    Starting the SQL Server Agent may trigger existing SQL Server jobs (including SSIS and maintenance plans) to run.
  • Enable Agent XPs via script if you cannot start the agent. This allows monitoring without starting the SQL Server Agent:
SP_CONFIGURE 'SHOW ADVANCE',1
GO
RECONFIGURE WITH OVERRIDE
GO
SP_CONFIGURE 'AGENT XPs',1
GO
RECONFIGURE WITH OVERRIDE
GO

Contact our support

If you have questions or need further assistance with the Nodinite Database Monitoring Agent, contact our support team at support@nodinite.com for expert help.