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


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




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


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



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.


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