Submit a ticketCall us

Welcome to the NEW Success Center. Search all resources (documentation, videos, training, knowledge base articles) or browse resources by product. If you are unable to find what you are looking for, please contact us at customersuccess@solarwinds.com

 

 

 

 

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