Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > IP Address Manager (IPAM) > IPAM Installation Guide > Stand-alone IPAM installation > Prepare the Orion SQL database

Prepare the Orion SQL database

Table of contents
No headers

Updated: June 1, 2017

This Installation Guide only applies to older versions of IP Address Manager. If you are installing IPAM 4.5.1 or later, see the SolarWinds Orion Installer installation steps instead.

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

For Orion Platform products, use a new or existing SQL database. Prepare your database using the following guidelines.

File:Success_Center/Reusable_content_-_InfoDev/IPAM_Installation_Guide/IPAM_Installation_Guide/0070-Uninstall_IPAM/checkbox.gif Make sure the database and database server meet the system requirements.
File:Success_Center/Reusable_content_-_InfoDev/IPAM_Installation_Guide/IPAM_Installation_Guide/0070-Uninstall_IPAM/checkbox.gif Ensure that you install the Orion database and the Orion Server on the same domain.
File:Success_Center/Reusable_content_-_InfoDev/IPAM_Installation_Guide/IPAM_Installation_Guide/0070-Uninstall_IPAM/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/Reusable_content_-_InfoDev/IPAM_Installation_Guide/IPAM_Installation_Guide/0070-Uninstall_IPAM/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/Reusable_content_-_InfoDev/IPAM_Installation_Guide/IPAM_Installation_Guide/0070-Uninstall_IPAM/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/Reusable_content_-_InfoDev/IPAM_Installation_Guide/IPAM_Installation_Guide/0070-Uninstall_IPAM/checkbox.gif

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

File:Success_Center/Reusable_content_-_InfoDev/IPAM_Installation_Guide/IPAM_Installation_Guide/0070-Uninstall_IPAM/checkbox.gif

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.

Last modified
12:13, 25 May 2017

Tags

Classifications

Public