Network Management
Troubleshooting Connection Issues Between SolarWinds Platform and Azure Database
Reviewing the connection metrics reveals intermittent failures when the SolarWinds Platform attempts to connect to the Azure database named SolarWindsOrion. Azure’s “Deny Public Network Access” setting being enabled can cause failures. This setting restricts access to the database from public networks, requiring connections to use a Private Endpoint within the virtual network.
First published date
Last published date
Overview
This article addresses connection problems observed between the SolarWinds Platform and an Azure SQL Database. Logs indicate multiple failed connection attempts, which can impact the platform’s ability to collect and process data effectively.
Product section
Cause
The connection failures are caused by Azure SQL Database’s security configuration where “Deny Public Network Access” is set to Yes. This prevents the SolarWinds Platform from establishing a connection over the public internet, enforcing the use of private network endpoints for database access.
Resolution
- Deny Public Network Access: https://docs.microsoft.com/azure/azure-sql/database/connectivity-settings#deny-public-network-access
- Private Endpoint Setup: https://docs.microsoft.com/azure/sql-database/sql-database-private-endpoint-overview#how-to-set-up-private-link-for-azure-sql-database