Network Management

Orion to SQL server connection time out

What to do if the Orion to the SQL server connection is timing out.

First published date

10/15/2018 4:51 PM

Last published date

9/15/2022 5:31 PM

Overview

Connection to the SQL server is timing out. The timeout settings can be modified through a configuration file on the application server. It should not be needed to increase these values. Although, they do exist and can be adjusted for troubleshooting purposes.

Product section

Orion Platform

Resolution

  • Stop all Orion services.
  • Create a backup of SWNetPerfMon.db, in case you need to roll it back later. The default location is: C:\Program Files (x86)\SolarWinds\Orion\SWNetPerfMon.DB.
  • Edit the SWNetPerfMon.db file in Notepad or any text editor.
  • Scroll down to the bottom of the file and change the timeout settings as follows:
Connection timeout in seconds Timeout=60
Database Command timeout in seconds CommandTimeout=600
SqlCommand.CommandTimeout in seconds SqlCommandTimeout=0
  • SqlCommandTimeout=0 is equivalent to infinite. If you have a High Availability server, you will need to edit the same value on this server.
  • Restart all Orion Services.