Submit a ticketCall us

Cloud Workloads: Meet Your New Hybrid IT Reality
Have you found yourself in that evolving, hybrid IT grey area and wondering if cloud workloads are now part of your purview? And if so, will monitoring cloud workloads require a new set of dedicated cloud monitoring tools? Your answers: yes, they should be, and no, they don’t.

Find out how SolarWinds® Server & Application Monitor (SAM) can help you monitor your cloud workloads side by side with your on-premises workloads. Register Now.

Home > Success Center > Storage Resource Monitor (SRM) > SRM Legacy Installation Guide > Prepare the Orion SQL Server database for a SolarWinds SRM installation

Prepare the Orion SQL Server database for a SolarWinds SRM installation

Table of contents
No headers
Created by Nigel, last modified by Nigel on Mar 14, 2017

Views: 92 Votes: 0 Revisions: 1

The SolarWinds Orion database stores all monitoring data. Use these guidelines to configure the database before you install and configure SolarWinds SRM. If you need assistance installing the SQL Server database, refer to the guidelines provided by Microsoft.

Ensure you install the Orion database and the Orion Server on the same domain.

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, for example, #, %, or ^

For a new database, the user account must be a member of the dbcreator server role. The sysadmin role and the security administrator (SA) user account are always members of dbcreator.

For an existing database, the user account needs only to be in the db_owner database role for the existing database.

For a new SQL account, the user account must be a member of the securityadmin server role. The sysadmin role and the security administrator user account are always members of securityadmin.

Set the recovery model of the database to Simple. SolarWinds does not support other methods.

Select the authentication method used by the SolarWinds Orion user to access the SolarWinds Orion database.

SolarWinds recommends using SQL Server Authentication to ensure the SolarWinds Orion server can always access the SolarWinds Orion database, even when hosted remotely on a separate server.

 
Last modified

Tags

Classifications

Public