Submit a ticketCall us

Training ClassSign up for Network Performance Monitor (NPM) and Scalability instructor-led classes

Attend our instructor-led classes, provided by SolarWinds® Academy, to discuss the more advanced monitoring mechanisms available in NPM as well as how to tune your equipment to optimize its polling capabilities. NPM classes offered:
NPM Custom Monitoring and Polling
Orion Platform Scalability

Reserve your seat.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Unexpected SQL Error. Connection Timeout Expired

Unexpected SQL Error. Connection Timeout Expired

Created by Wilard Bao, last modified by Craig Healy on Nov 05, 2018

Views: 5,866 Votes: 0 Revisions: 7

Overview

The following error occurs when NPM is trying to connect to SQL.

Environment

* Core all versions

Cause 

This issue is caused by a connection problem from NPM to SQL. This could be due to SQL user not having right permissions on SolarwindsOrionDB or some underlying network problem.

Resolution

  1. Open Database Manager and click Add default server.
    If the same error message appears, the connection to SQL needs to be fixed.
  2. Use telnet to verify if port 1433 is open.
  3. If it still does not connect, verify if there is something that is blocking the server from establishing a connection to the SQL server.

 

Resolution #2:

1, Run the configuration wizard again

2, Select all 3 choices, database/website/services

 

Resolution #3:

1, Reboot of the Orion server, you may also need to reboot the SQL server.

 

 

Last modified

Tags

Classifications

Public