Submit a ticketCall us

Putting Your Logs Where They Belong with the New SolarWinds Log Manager for Orion

The new SolarWinds® Log Manager for Orion® finally puts your log data right where it belongs, in the heart of your Orion console. Gain insight into the performance of your infrastructure by monitoring your logs in a unified console allowing you to see a wealth of information about the health and performance of your network and servers.

Reserve a Seat for Wednesday May 23rd 11am CDT | Reserve a Seat for Tuesday May 22nd 10:30am GMT | Reserve a Seat for Tuesday May 22nd 1pm SGT / 3pm AEST

Home > Success Center > Server & Application Monitor (SAM) > Server & Application Monitor (SAM) Getting Started Guide > Production installation > Prepare the Orion database for a SolarWinds SAM installation

Prepare the Orion database for a SolarWinds SAM installation

Table of contents
No headers

The Orion SQL Server database stores all monitoring data. Use the following guidelines to configure the database before you install and configure SolarWinds SAM. If you need assistance installing the SQL Server database, see the Microsoft guidelines.

File:Success_Center/New_Articles/NPM-Getting-Started-CHM/010/020/checkbox.gif Make sure the database and database server meet the system requirements.
File:Success_Center/New_Articles/NPM-Getting-Started-CHM/010/020/checkbox.gif Ensure that you install the Orion database and the Orion Server on the same domain.
File:Success_Center/New_Articles/NPM-Getting-Started-CHM/010/020/checkbox.gif

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 ^
File:Success_Center/New_Articles/NPM-Getting-Started-CHM/010/020/checkbox.gif

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.

File:Success_Center/New_Articles/NPM-Getting-Started-CHM/010/020/checkbox.gif

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

File:Success_Center/New_Articles/NPM-Getting-Started-CHM/010/020/checkbox.gif

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.

File:Success_Center/New_Articles/NPM-Getting-Started-CHM/010/020/checkbox.gif

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

File:Success_Center/New_Articles/NPM-Getting-Started-CHM/010/020/checkbox.gif

Select SQL Server Authentication. SolarWinds Orion users access the SolarWinds Orion database using this method.

SolarWinds uses 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