Submit a ticketCall us
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: 1,245 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

Tags

Classifications

Public