Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Netflow Traffic Analyzer (NTA) > NTA Install Error: Database Configuration Failed

NTA Install Error: Database Configuration Failed

Created by Michael Almadova, last modified by MindTouch on Jun 23, 2016

Views: 1,512 Votes: 0 Revisions: 4

Overview

This article provides brief information and steps to resolve the following NTA installation error: 

Database Configuration Failed: Error While executing script- The EXECUTE permissions was denied on the object 'sp_help_operator', database 'msdb', schema 'dbo'.

Environment

  • NTA version 4.1.1
  • NPM version 11.5.2

 

Cause 

The issue is caused by permission limitations with SQL. 

Resolution

  1.  Check permissions in SQL for the SolarWinds database.
  2. Database Authentication:

 

When you are configuring the SolarWinds Orion database, you are required to select the authentication method used by the NPM user to access the selected SolarWinds Orion database. SolarWinds recommends that you use SQL Server Authentication to ensure that the NPM server can always access the SolarWinds Orion database, even when it is hosted remotely on a separate server.

 

Note: The sysadmin role and the SA user account are always members of securityadmin.

 

  • The selected SQL Server instance must support mixed‑mode or SQL authentication with strong passwords.
    A strong password must meet at least three of the following four criteria:
    • Contains at least one uppercase letter.
    • Contains at least one lowercase letter.
    • Contains at least one number.
    • Contains at least one non-alphanumeric character, for example, #, %, or ^.
  • If you are using SQL Express, specify your instance as local and use a strong password. Due to its inherent limitations, SolarWinds does not recommend the use of SQL Express in production environments.
  • If you are creating a new database, the user account must be a member of the dbcreator server role. The sysadmin role and the SA user account are always members of dbcreator.
  • If you are using an existing database, the user account needs only to be in the db_owner database role for the existing database.
  • If you are creating a new SQL account for use with Orion NPM, the user account must be a member of the securityadmin server role.
  • If you are using an existing SQL account, the user account needs only to be in the db_owner database role for the SolarWinds Orion database.

 

 

Last modified

Tags

Classifications

Public