SCOM + SQL Always On - Listener won't accept the connection during installation

Dashboard Server
,
1

I’m having trouble getting the SCOM Installation to pick up a SQL instance behind a SQL AlwaysOn listener.

2017-07-27-16_05_30-Clipboard.png
2017-07-27-16_05_30-Clipboard.png737×555 25.8 KB

The setup logs show some generic errors

Error: :Error opening SQL connection.: Threw Exception.Type: System.Data.SqlClient.SqlException, Exception Error Code: 0x80131904, Exception.Message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 – The wait operation timed out.)
I can point the wizard directly to the SQL instances successfully, but using the listener name with or without the instance “SC2016” simply does not work.

More info:

  • SQL servers have two NICs, one for the cluster (18.18.18.x), one for the VM (172.x.x.x)
  • I’ve ensured the port is set correctly as 1433
  • SQL Server 2016, with SCOM 2016, running on a Server 2016 machine (upgrades!)
  • The installation wizard is using my account, which I’ve confirmed has login/create rights on both SQL instances
  • I’ve tried failing over the AG in case one node was the issue
  • Name resolution works from the SCOM MS
  • Firewalls are off on both networks
Annoyingly, I swear I ran into this a year or so ago but cannot for the life of me figure out what I’ve missed ?

2017-07-27-12_22_09-int-scom-ms01-Remote-Desktop-Connection.png
2017-07-27-12_22_09-int-scom-ms01-Remote-Desktop-Connection.png736×557 35.3 KB

2

Try installing SQL Server Management Studio on the SCOM server and see if you can connect to the SQL instance.

MS usually gives better error information that you can use to troubleshoot, and if it works it’s something to do with the SCOM setup

3

Pro tip – Speak to your networking guys when planning things. Turns out this was a subnetting issue.

Thanks for the assistance guys.

4

Just type the server name in the {Server name and instance name} then Hit the TAB button on your keyboard the DB will appearunderneath I have had this before worth ago

5

I have to setup a new SCOM lab in the next few days so I’ll try this and see if I get the same results

6

Awesome! Thanks Liam. In order to progress my lab, I’ve pointed SCOM at a single SQL server and will be migrating as per some articles I’ve found online :slight_smile: I’m intrigued to see if you find similar results though :slight_smile: