Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

Home > Success Center > Network Performance Monitor (NPM) > Unable to open new database connection

Unable to open new database connection

Overview

The traps are not visible in Trap viewer. The following message is received:

 

Error:
Service was unable to open new database connection when requested.

Exception Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.


Connection string - Data Source=naag01.corp.service-now.com\MSSQL2012;Initial Catalog=SolarNPM;User ID=sql_solarnpm;Password=*******;Connect Timeout=20;Load Balance Timeout=120;Application Name="Solarwinds Trap Receiver Service";Workstation ID=SJC4SOLAR02

 

Environment

NPM V11 through version 11.5.2

Cause 

Database connections have run out of pooled connections. Theoretical maximum is 100 connections per process (default Connection Pool limit). 

Resolution

SolarWinds recommends to increase the connection pool size on the Main Poller as this hosts Traps\Syslogs and Alerts Services.
This could also be applied on Additional Pollers or any additional Web Server, if needed.

 

  1. Create a back up of SWNetPerfMon.db located in 
  2. C:\Program Files (x86)\SolarWinds\Orion\SWNetPerfMon.DB, in case you need to roll back later.
  3. Edit the SWNetPerfMon.db using notepad or any text editor, to have Max Pool Size = 1000..You need to  add the following line before 'Persist Security Info=': Max Pool Size = 1000;
    Note: You only need to edit the top 3 strings, as the product has archived the connection strings not used in the file.
  4. Save the file and exit.
  5. Restart the Orion Services using the Orion Service Manager.
Last modified

Tags

Classifications

Public