Monitor SQL instances over double hop gateway

Dashboard Server
, ,
1

Hi all,

I’m trying to monitor a SQL instance over a double hop SCOM 2022 gateway. The gateway is working fine and I am receiving events and alerts from the SQL server in the non trusted domain but I can’t get the SCOM Management server in the main domain to monitor the SQL instance.

I can telnet on port 1433 from the SCOM MS and a ODBC test works fine too. I’ve been through Kevin Holman’s piece here ( SQL MP Run As Accounts – NO LONGER REQUIRED – Kevin Holman's Blog) but no dice.

I don’t really want to use a domain based “run as account” for the untrusted domain as I would like the LOCALSERVICE\HEALTHSERVICE SQL login to be enough but I guess I may have to do down this route.

There don’t seem to be any errors in any of the SQL logs or any of the SCOM component Operations Manager event logs either,

Any help would be gratefully received.

Thanks

Nick

2

Hi Nick

If there are no errors in the Operations Manager event log on either the SCOM Management Servers in the SQL Server Monitoring Pool or on the local SQL Server error log then it sounds like the configuration hasn’t been complete.

What monitoring mode are you using for SQL Monitoring?
Monitoring modes in Management Pack for SQL Server | Microsoft Learn

A few questions:

  1. Is there a reason not to use the local agent (agent monitoring) to monitor the SQL Server?
  2. If you look in the SCOM console (or in SquaredUp if you have Dashboard Server), do you see the SQL instance and databases discovered?

Cheers

Graham