Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Network Configuration Manager (NCM) > Database configuration failed: exception while configuring plugin SolarWinds NCM integration plugin component orion database update. Alter failed for table 'dbo.NCM_NCMJobs'

Database configuration failed: exception while configuring plugin SolarWinds NCM integration plugin component orion database update. Alter failed for table 'dbo.NCM_NCMJobs'

Created by Norsolihati Selamat, last modified by Rodim Suarez on Jul 10, 2016

Views: 101 Votes: 0 Revisions: 5

Overview

The following error appears during Configuration Wizard:

Database configuration failed: exception while configuring plugin Solarwinds ncm integration plugin component orion database update. Alter failed for table 'dbo.NCM_NCMJobs'.

 

Error on the Configuration Wizard log:

ERROR ConfigurationProgressScene - Exception while configuring plugin SolarWinds NCM Integration Plugin component Orion Database Update. Microsoft.SqlServer.Management.Smo.FailedOperationException: Alter failed for Table 'dbo.NCM_NCMJobs'. ---> Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'xp_instance_regread', database 'mssqlsystemresource', schema 'sys'.
The EXECUTE permission was denied on the object 'xp_instance_regread', database 'mssqlsystemresource', schema 'sys'.

at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnection.GetExecuteReader(SqlCommand command)

Environment

NCM 7.3

Cause 

The SQL credential used to run the Orion Configuration Wizard is lacking in permission.

Resolution

  1. Grant EXEC Permissions to the SQL user account where the Configuration Wizard is executed.
  2. Or, use the SQL SA account run Configuration Wizard. Please contact your DBA in order to grant such permission and correct the issue further. 

 

Last modified
17:21, 10 Jul 2016

Tags

Classifications

Public