Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Web Performance Monitor (WPM) > WPM is unable to open a new database connection

WPM is unable to open a new database connection

Updated: December 20, 2017

Overview

 

Since the upgrade to NPM 12.2 (Or any module which is using Orion Core 2017.1 or newer) now support Windows Authentication for SQL Server.

 

2017-12-14 16:36:38,580 [Main] ERROR SolarWinds.Orion.Common.SWEventLogging - Service was unable to open new database connection when requested.
SqlException: Login failed for user 'Domain\Username$'.
Connection string - Data Source=SQLServerHostname;Initial Catalog=SQLServerHostname;Integrated Security=True;Persist Security Info=False;Max Pool Size=1000;Connect Timeout=20;Load Balance Timeout=120;Packet Size=4096;Application Name=SolarWinds.BusinessLayerHost@do...ll;Workstation ID=SolarwindsServerHostname
2017-12-14 16:36:39,548 [Main] WARN  SolarWinds.Orion.Common.SWEventLogging - WPM Service [SUP-COR-SHOR-01] Database connection verification failed

Environment

  • WPM 2.2.1 & Orion Core 2017.1+

 

Cause 

  • Since the upgrade to NPM 12.2 (Or any module which is using Orion Core 2017.1 or newer) now support Windows Authentication for SQL Server.
  • WPM Currently does not support Windows Authentication for SQL Server so it is unable to connect to the SQL instance when this property is selected during the configuration wizard.

 

Resolution

  1. Log into the Solarwinds Server.
  2. Run the Configuration Wizard as administrator.
  3. Select use SQL Authentication when prompted for which user to connect to the Orion Database.


image.png

 

 

 

 

 

Last modified

Tags

Classifications

Public