SQL Agent Not Working for Server

Hi All,

I have two servers for which I am trying to monitor my SQL server environment.

One of the servers works very well but the other doesn’t seem to be connecting to New relic (for SQL) although it is visible at the server level.

I followed the same install guide for each server and the (slightly modified) mssql-config.yml scripts are below:

Can anyone suggest what I have done wrong or how to troubleshoot it please?

The only obvious difference is that one uses an instance while the other uses a port.
I am aware that you can’t use both at the same time but even when I try using the instance name (“MSSQLSERVER” ) in place of the port it doesn’t work.

I would really appreciate any advice on how to proceed.

Thanks in advance.

Working Server:

instances:
  - name: WORKINGSERVER01
    command: all_data
    arguments:
      hostname: WORKINGSERVER01
      instance: UniqueInstanceName
      username: newrelic
      password: FakePassword
      # NEW ROWS
      enable_buffer_metrics: false
      enable_database_reserve_metrics: false
      # port: 1433   
    labels:
      env: production
      role: mssql

Not Working Server:

instances:
  - name: NOTWORKINGSERVER02
    command: all_data
    arguments:
      hostname: NOTWORKINGSERVER02
      port: 1433 
      username: newrelic
      password: FakePassword
      # NEW ROWS
      enable_buffer_metrics: false
      enable_database_reserve_metrics: false  
      # instance: MSSQLSERVER
    labels:
      env: production
      role: mssql

Those look ok jortt. Be interested what the outcome is.
Assuming same versions of SQL and Windows Server and that the creds work when logging into the DB?