Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > Network Configuration Manager (NCM) > 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
14:19, 13 Nov 2015

Tags

Classifications

Public