Monitor 2023.3.1: Unable to register a component: SQL Server

[RickChu]

Hello,

We have recently setup ArcGIS Monitor 2023.3.1. I have registered several components but I'm having trouble registering a SQL Server component.. 

On the screen where you configure the Address, Database, username and password, I filled in the fields and clicked "Register Component". After a few seconds I get this message:

An error occurred running the observer

Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call?

I have verified that the userid and password are correct and that no firewalls are blocking access to SQL Server.

I had no trouble adding a Postgresql server

Any thoughts on what may cause this error?

[RickChu · Accepted solution]

There is another post for the same error but a different ESRI product. They recommended restarting the service. I restarted ArcGIS Monitor Service and Postgresql. After the restart, I was able to register SQL Server. 

I don't know the root cause, but it appears that my problem is resolved. 

[StevenBeothy]

I had a client who had this same error and their issue was resolved by them updating their NSG in Azure to allow the ArcGIS Monitor server. Check to see if you have a firewall rule blocking the ArcGIS Monitor Server or Agent.

[Shawn_NG]

@RickChu Since your are registering SQL Server database, did you follow the pre-requisite steps mentioned in document https://doc.arcgis.com/en/monitor/2023.3/get-started/windows/register-sql-server-databases.htm#ESRI_...