Submit a ticketCall us
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: 48 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
20:56, 22 Jun 2016

Tags

Classifications

Public