Submit a ticketCall us

Bridging the ITSM Divide
Integrated help desk and remote support software for faster resolution

Join us on Wednesday, November 29, 2017 at 11 a.m. CT, as we discuss the benefits of effectively integrating your help desk software with remote support solutions to help increase the efficiency of IT administration, improve communication, and decrease mean time to resolution (MTTR) for IT issues of all sizes. This directly impacts end-user satisfaction and your business’ bottom line. Register Now.

Home > Success Center > Network Performance Monitor (NPM) > MS SQL support for MultiSubnetFailover=true

MS SQL support for MultiSubnetFailover=true

Table of contents
Created by Malik Haider, last modified by MindTouch on Jun 23, 2016

Views: 106 Votes: 0 Revisions: 6

Overview

MS SQL is required to enable Orion with MultiSubnetFailover=true in connection string.

User is required to manually modify the Orion database connection string to enable this parameter.

Without this connection string parameter to the database, the connection times out and will not complete.

Environment

All Orion Core products

Detail

There is no configuration or connection attribute that is officially supported.

The functionality that you require is currently not in our product. 

 

Orion Database Authentication and requirements 

When you are configuring the SolarWinds Orion database, you are required to select the authentication method used by the NPM user to access the selectedSolarWinds Orion database. In general, SolarWinds recommends that you use SQL Server Authentication to ensure that the NPM server can always access theSolarWinds Orion database, even when it is hosted remotely on a separate server.

Notes:

  • The selected SQL Server instance must support mixed‑mode or SQL authentication with strong passwords.
    A strong password must meet at least three of the following four criteria:
    • Contains at least one uppercase letter.
    • Contains at least one lowercase letter.
    • Contains at least one number.
    • Contains at least one non-alphanumeric character, e.g., #, %, or ^.
  • If you are using SQL Express, specify your instance as (local) and use a strong password. Due to its inherent limitations, SolarWinds recommends against the use of SQL Express in production environments.
  • If you are creating a new database, the user account must be a member of the dbcreator server role. The sysadmin role and the SA user account are always members of dbcreator.
  • If you are using an existing database, the user account needs only to be in the db_owner database role for the existing database.
  • If you are creating a new SQL account for use with Orion NPM, the user account must be a member of the securityadmin server role.

NoteThe sysadmin role and the SA user account are always members of securityadmin.

  • If you are using an existing SQL account, the user account needs only to be in the db_owner database role for the SolarWinds Orion database.



The requirements for SQL server is depicted in our NPM Admin Guide:
http://www.solarwinds.com/documentat...ratorGuide.pdf

 

 

 

 

Last modified

Tags

Classifications

Public