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 Performance Monitor (NPM) > Cannot create new Table (Accounts) ExecuteNonQuery failed for Database 'netperfmon'

Cannot create new Table (Accounts) ExecuteNonQuery failed for Database 'netperfmon'

Created by Daniel Polaske, last modified by Daniel Polaske on Aug 10, 2016

Views: 403 Votes: 1 Revisions: 12

Overview

When running the Configuration Wizard, you encounter the following error:

Database configuration failed: - Cannot create new Table (Accounts) ExecuteNonQuery failed for Database 'netperfmon'.

Environment

Orion NPM 10 or later with Microsoft SQL Server 2008.

Cause 

This error condition may be confirmed if the ConfigurationWizard.log reports any assembly load errors for Microsft.SqlServer.BatchParser v10.0.0.

This can also appear when trying to connect a version of the database that is lower than the currently installed application version.

 

~~ You can also see the issue within the logs as below ~~ 

 

Note: The time required to configure the Orion database depends on its size. It may take a while to configure a larger database.
2016-05-22 00:42:33,964 [13] DEBUG DBStructureProcessor - Updating Accounts table within the Solarwinds database...
2016-05-22 00:42:34,292 [13] ERROR DBStructureProcessor - Cannot create new Table (Accounts)Microsoft.SqlServer.Management.Smo.FailedOperationException: ExecuteNonQuery failed for Database 'Solarwinds'.  ---> Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: CREATE TABLE permission denied in database 'Solarwinds'.

2016-05-22 00:42:34,307 [13] ERROR ConfigurationProgressScene - Cannot create new Table (Accounts) ExecuteNonQuery failed for Database 'Solarwinds'. 
SolarWinds.ConfigurationWizard.Common.ConfigurationException: Cannot create new Table (Accounts) ExecuteNonQuery failed for Database 'Solarwinds'. 

 

 

 

 

Resolution

Note: Use an sa account when connecting to the Database.

  1. To resolve this error, download and install Microsoft® SQL Server® 2008 R2 Shared Management Objects (x86 package) from Microsoft SQL Server 2008 Feature Pack, April 2009.


Microsoft® SQL Server® 2008 R2 Shared Management Objects

  • The SQL Server Management Objects (SMO) is a .NET Framework object model that enables software developers to create client-side applications to manage and administer SQL Server objects and services. This object model will work with SQL Server 2000, SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.
    Note: Microsoft SQL Server 2008 R2 Management Objects Collection requires Microsoft Core XML Services (MSXML) 6.0, Microsoft SQL Server Native Client, and Microsoft SQL Server System CLR Types. These are available on this page.
     
  1. Alternatively, if retention of historical data is not a concern, you may also create a new database.

 

 

Resolution # 2


Kindly ask your DBA to give the SolarWindsNPM account 'db_owner" access to Orion database
Once done re run  the Configuration wizard . 

 

 

 

 

 

Last modified
09:29, 10 Aug 2016

Tags

Classifications

Public