Submit a ticketCall us

WebinarUpcoming Webinar: Should I Move My Database to the Cloud?

So you’ve been running an on-premises SQL Server® for a while now. Maybe you’ve moved it from bare metal to a VM, and have seen some positive benefits. But, do you want to see more? If you said “YES!”, then this session is for you, as James Serra will review the many benefits that can be gained by moving your on-prem SQL Server to an Azure® VM (IaaS). He’ll also talk about the many hybrid approaches, so you can gradually move to the cloud. If you are interested in cost savings, additional features, ease of use, quick scaling, improved reliability, and ending the days of upgrading hardware, this is the session for you.

Register now.

Home > Success Center > Network Performance Monitor (NPM) > Cannot open database NetPerfMon requested by the login in NPM

Cannot open database NetPerfMon requested by the login in NPM

Updated: December 13, 2017

Overview

DB maintenance failing with long running queries and database connection errors.

Environment

  • NPM
  • NPM 11.5.2

 

Cause 

Errors in DB maintenance:

 

ERROR SolarWinds.Data.DatabaseMaintenance.NetworkElements - Failed to cleanup deleted network elements tables.
System.Data.SqlClient.SqlException (0x80131904): Cannot open database "NetPerfMon" requested by the login. The login failed.
Login failed for user 'SolarWinds'.
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   DeletedElements()
 

ERROR SolarWinds.Orion.Common.SWEventLogging - Service was unable to open new database connection when requested.
SqlException: Cannot open database "NetPerfMon" requested by the login. The login failed.
Login failed for user 'SolarWinds'.

Connection string - Data Source=sjmonsqlprdg01.na.gilead.com;Initial Catalog=NetPerfMon;Persist Security Info=False;User ID=SolarWinds;Password=*******;Max Pool Size=1000;Connect Timeout=1200;Load Balance Timeout=120;Packet Size=4096;Application Name=DatabaseMaintenance@Database-Ma...xe;Workstation ID=SolarWinds
2017-12-07 03:19:25,195 [1] ERROR DatabaseMaintenanceGui.Program - Database Maintenance Error.
System.Data.SqlClient.SqlException (0x80131904): Cannot open database "NetPerfMon" requested by the login. The login failed.
Login failed for user 'SolarWinds'.
 at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
 

Resolution

  1. The customer was installing SQL server patches at the time of maintenance running that caused this and should not patch SQL server during DB maintenance running.
 

 

Last modified

Tags

Classifications

Public