Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register 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: 129 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