Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

Home > Success Center > Network Configuration Manager (NCM) > NCM - Knowledgebase Articles > The SolarWinds NCM software was unable to get data from SQL server

The SolarWinds NCM software was unable to get data from SQL server

Created by Brian O'Donovan, last modified by Caroline Juszczak on Oct 13, 2017

Views: 1,080 Votes: 0 Revisions: 8

Overview

The following error message is received when launching the NCM tool:

The SolarWinds NCM software was unable to get data from SQL server:
[
Cannot open database "pm" requested by the login. The login failed.
Login Failed for user "sa".
]

Environment

NCM 7.2.2 and earlier

Cause 

This issue is caused by running the Orion Configuration Wizard and creating a new database instead of connecting to the existing DB. This broke the NPM / NCM integration.

Resolution

  1. Run NCM Configuration Wizard.
    1. Go to Start > SolarWinds Orion > Network Configuration Manager > SolarWinds NCM Configuration Wizard.
    2. Verify the settings.
    3. Complete the wizard.
  2. Run Orion Configuration Wizard.
Last modified

Tags

Classifications

Public