Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > User Device Tracker (UDT) > UDT legacy installation guide > 0080-Install UDT standalone > Prepare the Orion SQL database for UDT standalone

Prepare the Orion SQL database for UDT standalone

Table of contents
No headers

When installing UDT as a stand-alone product, you need to prepare a dedicated server for an SQL server.

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

Important: Install the SQL database on a dedicated server. You should not install it on the Orion server.

Make sure the database and database server meet the system requirement for a stand-alone installation of SolarWinds UDT.
Ensure that 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 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 SQL Server Authentication. SolarWinds Orion users use this method to access the SolarWinds Orion database.

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.

As you continue using Orion products, you should actively maintain and manage the Orion SQL database. See Best practices for managing your Orion database for tips, tricks, and maintenance recommendations.

 
Last modified

Tags

Classifications

Public