Submit a ticketCall us

AnnouncementsWeb Help Desk Integrations eCourse

Looking to reduce response times? Sign up for our eCourse to learn how integrating Web Help Desk with Dameware Remote Support, Network Configuration Manager, Network Performance Monitor, and Server & Application Monitor can improve communication efficiencies.

Register here.

Home > Success Center > Orion Platform > Orion - Knowledgebase Articles > Configuration wizard issues due to Basic SQL AlwaysOn on SQL 2016

Configuration wizard issues due to Basic SQL AlwaysOn on SQL 2016

Created by Kevin Twomey, last modified by Magdalena.Markova on Apr 11, 2018

Views: 222 Votes: 0 Revisions: 23

Updated 21st Jan 2018

Overview

After running the SolarWinds Orion online installer, the Configuration wizard fails with an SQL exception.

  • Every time the Configuration wizard runs, it adds a new connection entry to the SWNetPerfMon.db file.
  • The source only states the SQL server name (not the SQL server name/instance as is required).

 

Configuration error that occurred after running the SolarWinds Orion online installer:

ERROR Configuration Progress Scene - Exception while configuring plugin Orion Core Services component Orion Database>. System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred

 

33333.png

Environment

  • NPM 12.2 HF4, SAM 6.5
  • SQL 2016
  • SQL AlwaysON

Cause 

This issue is on the SQL side.

  • You are using Basic AlwaysOn on your SQL server, and the AlwaysOn listener has a named instance, for example: mylistener\myinstance. The Configuration wizard strips the instance and fails.
  • Your Orion Platform product is having issues because you are using SQL AlwaysOn with no instance, but only a server name.


As a result, the C:\Program Files (x86)\SolarWinds\Orion\SWNetPerfmon.DB file is incorrect
because there are no users with Named Instance on the listener. It's not common nor expected.

SQL Setup in SQL Mgmt Studio

SQL AlwaysON Setup.PNG

In the Orion SWNetPerfmon.db

22222.PNG

Resolution

If SQL AlwaysOn is always running on a unique port 1451, add the port to Configuration wizard to stop instance from being stripped.

To resolve the issue:

  1. Run the Configuration wizard.
  2. In the Database Settings, use "mylistener,port" as the SQL Server if the port is unique for every instance on the listener.

    222.PNG

The Configuration wizard now completes successfully.

You can also specify the SQL AlwaysOn port in the SWNetPerfMon.db file:

  1. Open C:\Program Files (x86)\SolarWinds\Orion\SWNetPerfmon.DB in a text editor.
  2. Specify the following as the Instance Name:  [ServerName], [SQLalwaysOnPort]
    Example: DBServer-11, 1451  

The database file will remain correct and you can run the Configuration wizard on any polling engines.

 

 

Suggested Tags:  HA-4367

 

A reason for rework or Feedback from Technical Content Review:

 

 

Last modified

Tags

Classifications

Public