Hide this message
Welcome to the NEW Success Center. Search all resources (documentation, videos, training, knowledge base articles) or browse resources by product. If you are unable to find what you are looking for, please contact us at firstname.lastname@example.org
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'.
The issue is caused by permission limitations with SQL.
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.