Hide this message
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.
The database selection screen where the new database is specified is not responding after clicking Next.
This can happen during a Configuration Wizard run after a database was migrated to a cluster.
There are currently two known causes for this issue, both of which can be found via unique error messages in the ConfigurationWizard.log file -
The following error message can found in the log:
< 2016-02-19 17:20:59,442  ERROR SceneContainer - SceneContainer:bntNext_Click: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=126.96.36.199, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.SqlServer.ConnectionInfo, Version=188.8.131.52, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
at SolarWinds.ConfigurationWizard.Host.Presentation.DatabaseConfiguration.DatabaseServerScene.DoValidateConfig(Boolean silentMode) >
Alternatively, you may see the following error in the ConfigurationWizard.log file:
ERROR SceneContainer:bntNext_Click: Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.Sqlclient.SqlExceptions: The EXECUTE permission was denied on the object 'xp_instance_regread' , database 'mssqlsystemresource', schema 'sys'.
All NPM versions
The user is missing the Microsoft SQL Server 2012 Shared Management Objects application, or
If you see the The EXECUTE permission was denied on the object 'xp_instance_regread' , database 'mssqlsystemresource', schema 'sys'.
this indicates that the SQL user specified in the Configuration Wizard needs to have the 'sysadmin' server role applied in SQL Server Management Studio.
1. Add the 'sysadmin' server role to the specified user in SQL Management Studio (https://technet.microsoft.com/en-us/...ql.110%29.aspx)