Submit a ticketCall us

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.

 

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: 17 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
22:43, 22 Jun 2016

Tags

Classifications

Public