Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

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,097 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