Submit a ticketCall us

AnnouncementsSystem Monitoring for Dummies

Tired of monitoring failures disrupting the system, application, and service? Learn the key monitoring concepts needed to help you create sophisticated monitoring and alerting strategies that can help you save time and money. Read the eBook.

Get your free eBook.

Home > Success Center > Network Configuration Manager (NCM) > NCM - Knowledgebase Articles > NCM and Database Connectivity Issues

NCM and Database Connectivity Issues

Table of contents
No headers

Issue:

SQL becomes unresponsive due to crash, server reboot, maintenance, etc., and NCM is unable to connect to SQL. The following error is noticed:

Service cannot be started. System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'SolarWindsNCMLogon'.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 

Resolution:

Run the NCM configuration wizard selecting all the following options:

 

 

  • Database 
  • Services 
  • Startup Settings 


Click through the wizard until you get to the "Database Account" setting and create a new SQL account. Proceed through the configuration wizard and allow it to run. When the configuration wizard is complete, verify that NCM is able to connect to SQL.

 

Last modified

Tags

Classifications

Public