Network Management

NCM and Database Connectivity Issues

NCM cannot connect to SQL Server after a crash, reboot, or maintenance.

First published date

6/5/2019 9:54 PM

Last published date

6/5/2019 9:54 PM

Overview

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()

Product section

Network Configuration Manager

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.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.