Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

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 Abdul.Aziz on May 22, 2018

Views: 4,969 Votes: 0 Revisions: 6

Overview

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

Environment

  • NPM v10.x
  • NPM v11.x
  • NPM v12.x

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 Firewall

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: Run the configuration wizard again and select all 3 choices, database/website/services and this should resolve the error.

 

Resolution #3: Verify SolarwindsOrionUser permission on SolarwindsOrionDB

 

 

Last modified

Tags

Classifications

Public