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

10/15/2018 2:18 PM

2/14/2022 1:12 AM

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

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

Network Performance Monitor

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'. 

Option 1

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 (© 2019 Microsoft, available at https://www.microsoft.com, obtained on January 24, 2019).

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.
• Alternatively, if retention of historical data is not a concern, you may also create a new database.

Option 2

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

Disclaimer: Please note, any content posted here is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.  You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.