Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Network Performance Monitor (NPM) > Report resource failed to properly initialize

Report resource failed to properly initialize

Created by Dennis Harnett, last modified by Brian.Jarchow on Jun 26, 2017

Views: 460 Votes: 1 Revisions: 5


Reports fail to run intermittently. A resource fails to initialize. There are SQL errors in the logs, and event viewer.

Issue appears to be sql related.


NPM 11.5.2 through 12.1


Service was unable to open a new database connection when requested.

SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
Connection string - Data Source=EPBYMINSA0080t5\Infrastructure;Initial Catalog=NetPerfMon;Persist Security Info=False;User ID=SolarwindsNPM;Password=*******;Connect Timeout=20;Load Balance Timeout=120;Packet Size=4096;Application Name=w3wp@/LM/W3SVC/2/ROOT-1-131055500019036793;Workstation ID=SolarWinds

There are a number of long running queries in the logs:

C:\Users\SDAsvc\AppData\Local\Temp\DiagnosticsAnalyzer\5d9501bb-eca6-435e-ab1b-4e02b8a27315\Diagnostics\LogFiles\InformationServiceV3\Orion.InformationService.log, Line 23116, Message: '2016-04-24 02:29:30,655 [32] WARN SolarWinds.InformationService.Core.InformationService - (null) Support! -- LONG RUNNING QUERY: Session uuid:1e924326-f641-4606-abc9-ccaef27db18c;id=17 - Query took 19678.7153 ms: SELECT AlertObjectID FROM Orion.AlertObjects ao LEFT JOIN Orion.NPM.Interfaces no ON ao.EntityUri=no.Uri WHERE no.Uri IS NULL AND ao.EntityType = 'Orion.NPM.Interfaces' RETURN XML RAW'

These all point to an SQL performance/connection issue. See the following Microsoft articles for further information:

Enable TCP/IP Network Protocol for SQL Server

How to: Enable or Disable a Server Network Protocol (SQL Server Configuration Manager)


Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.  You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.


Last modified