Validate the SQL server settings to troubleshoot connection timeout issue

6/9/2021 8:29 AM

6/5/2026 10:48 PM

The SolarWinds Platform server is having a database connection timeout error below in the Event viewer or Orion.InformationService.log:

• System.Data.SqlClient.SqlException (0x80131904): 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 remote computer refused the network connection.) ---> System.ComponentModel.Win32Exception (0x80004005): The remote computer refused the network connection

Network Performance Monitor

This SQL server settings for connection may not set correctly causes the connection timeout error.

Resolution 1:
Check the SQL server configuration:

1. RDP to the SolarWinds Platform database server.
2. Run the SQL Server Configuration Manager.
3. Navigate to SQL Server Network Configuration > Protocol for [Database].
4. Ensure that the Named Pipes and TCP/IP is set to Enabled:
   • 
5. Right-click TCP/IP and select Properties, go to the IP Addresses tab.
6. Scroll and locate your SQL server IP address or replace 169.x.x.x with your SQL server IP address
7. Ensure that the IP address of the SQL server is set to enabled and the TCP port is correct:
   • 
8. Run the SQL Server Management Studio.
9. Right-click the SQL server, select properties and go to the Connections tab.
10. Ensure that 'Allow remote connections to this server is selected:
    • 

Resolution 2:
Adjust the SQL timeout settings in the SolarWinds Platform server:

1. Navigate to Volume:\Program Files (x86)\SolarWinds\Orion\.
2. Create a backup of SWNetPerfMon.db, in case you need to roll it back later.
3. Edit the SWNetPerfMon.db file using Notepad or any text editor.
4. Search 'Max Pool Size=1000' and replace the top 3 instances with 'Max Pool Size=5000'
5. Change the connect timeout to = 120 from 20
6. Go to the bottom of SWNetPerfMon.db and edit the following:
   • Connection timeout in seconds Timeout=60
     Database Command timeout in seconds CommandTimeout=900
     SqlCommand.CommandTimeout in seconds SqlCommandTimeout=0 
7. Save the file and exit.
8. Restart the SolarWinds Services using the SolarWinds Platform Service Manager.

===========================================
*Take note that the settings in the SWNetPerfMon.db file will be reverted back to the default values after upgrading or running the Configuration Wizard and the default values as below:

Connection timeout in seconds Timeout=20
Database Command timeout in seconds CommandTimeout=90
SqlCommand.CommandTimeout in seconds SqlCommandTimeout=0

Resolution 3:

1.    Run the Configuration Wizard
2.    Under Database Settings, specify the SQL server port after the server name/IP Address (even if using the default port)
3.    
4.    Complete the Configuration Wizard process and make sure all SolarWinds Platform Services are up and running