Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

Home > Success Center > Orion Platform > Orion - Knowledgebase Articles > Configuration wizard 'Next' button does nothing for database connection

Configuration wizard 'Next' button does nothing for database connection

Updated: February 20, 2019

Overview

The database selection screen where the new database is specified is not responding after clicking Next.

This can happen when running the Configuration wizard after a database was migrated to a cluster.

 

There are two known causes for this issue. Search the ConfigurationWizard.log file for the following error message

Error message 1

< 2016-02-19 17:20:59,442 [1] ERROR SceneContainer - SceneContainer:bntNext_Click: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

File name: 'Microsoft.SqlServer.ConnectionInfo, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
   at SolarWinds.ConfigurationWizard.Host.Presentation.DatabaseConfiguration.DatabaseServerScene.DoValidateConfig(Boolean silentMode) >

 

Error message 2

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

Environment

Orion Platform 2018.2 and earlier

Cause 

The issue might be caused by one of the following options:

  • The user is missing the Microsoft SQL Server 2012 Shared Management Objects application.
  • The SQL user specified in the Configuration wizard does not have the 'sysadmin' server role applied in the SQL Server Management Studio. This is indicated by the following error:

The EXECUTE permission was denied on the object 'xp_instance_regread' , database 'mssqlsystemresource', schema 'sys'.

 

Resolution

To resolve the issue when you don't have the Shared Management Objects application installed:

  1. Download Microsoft® SQL Server® 2012 Shared Management Objects.
  2. At the top of the page, click + to expand Install Instructions.
  3. Scroll down to Microsoft® SQL Server® 2012 Shared Management Objects downloads for both x86 and x64.
    Download both packages and rename them while downloading.
  4. Restart the Configuration wizard.

Connection to the specified database should now be available and the Next button should work.

 

 

To resolve the issue when the SQL user does not have the sysadmin server role:

  1.  Add the 'sysadmin' server role to the specified user in SQL Management Studio. For details, see the following Microsoft article on creating, deleting, or modifying a role (© Microsoft 2019, available at https://technet.microsoft.com/en-us/...ql.110%29.aspx, obtained on February 20, 2019)

Disclaimer: Please note, any content posted herein 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.

 

Last modified

Tags

Classifications

Public