Network Management

What authentication type to use for accessing the Orion SQL database

You can use both Windows Authentication (SQL Authentication disabled) or mixed mode authentication (both SQL Authentication and Windows Authentication enabled) for database connections from the Orion server to the SQL server.

First published date

11/15/2018 3:41 PM

Last published date

3/29/2022 12:55 AM

Overview

SolarWinds supports both Windows and SQL accounts. The SQL instance can be set up in mixed mode, using Windows or Azure Active Directory Authentication, or SQL Server authentication.

Product section

Orion Platform

Cause

n/a

Resolution

During the setup of your SQL Server, you must select an authentication mode for the database engine. 

Orion Platform products support both authentication modes:

  • Windows Authentication - SQL Server Authentication is disabled

  • Mixed mode Authentication - both Windows Authentication and SQL Server Authentication are enabled

See Choose an Authentication Mode (© 2019 Microsoft, available at https://docs.microsoft.com/, obtained on November 11, 2019)  in Microsoft documentation for more details.

When you configure the SolarWinds Orion database, you are required to select the authentication method used by the Orion user to access the selected SolarWinds Orion database.
When using Windows authentication, ensure that your Windows account is exempt from password expiration policies. If the password the Orion Platform uses to connect to the Orion database expires, the Orion Platform will stop working until the password is updated by re-running the Configuration wizard.

For the Database Account on the Configuration Wizard, create a new account by selecting a new account and creating a password.

For more information, see Prepare the SolarWinds Orion database server.