Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

 

 

 

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,008 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