Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

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