Submit a ticketCall us

Bridging the ITSM Divide
Integrated help desk and remote support software for faster resolution

Join us on Wednesday, November 29, 2017 at 11 a.m. CT, as we discuss the benefits of effectively integrating your help desk software with remote support solutions to help increase the efficiency of IT administration, improve communication, and decrease mean time to resolution (MTTR) for IT issues of all sizes. This directly impacts end-user satisfaction and your business’ bottom line. Register Now.

Home > Success Center > Patch Manager > Patch Manager Installation Guide > Plan for a production deployment > Determine and set up the database

Determine and set up the database

Table of contents
No headers

Complete the following checklist for the SolarWinds Patch Manager database. This checklist helps you:

  • Determine the SQL database that meets your deployment requirements
  • Gather the information required to set up and configure the database
File:Success_Center/Reusable_content_-_InfoDev/SPM/Patch_Manager_2-1-4_Installation_Guide/0030-Install_Patch_Manager/0050-Activate_the_Patch_Manager_license/checkbox.gif 1. Choose a database option

SolarWinds Patch Manager supports the following SQL databases:

  • Microsoft® SQL Server® Express
  • Microsoft SQL Server Standard or Enterprise Edition

If you choose SQL Server Express, the database is installed on the SolarWinds Patch Manager server during the installation. No additional configuration is required.

SQL Server Express has a 10 GB storage limit. If you exceed this limit, you must migrate your database to a remote SQL server.

If you choose SQL Server Standard or Enterprise Edition, you must install the database on a separate server prior to installing SolarWinds Patch Manager.

SolarWinds recommends this option to prevent a single point of failure.

File:Success_Center/Reusable_content_-_InfoDev/SPM/Patch_Manager_2-1-4_Installation_Guide/0030-Install_Patch_Manager/0050-Activate_the_Patch_Manager_license/checkbox.gif

2. Set up the database server

(Standard and Enterprise Edition only)

  1. Ensure that the server meets the SQL server requirements.
  2. Install and configure the SQL Server database software.

    See the Microsoft TechNet website for details.

File:Success_Center/Reusable_content_-_InfoDev/SPM/Patch_Manager_2-1-4_Installation_Guide/0030-Install_Patch_Manager/0050-Activate_the_Patch_Manager_license/checkbox.gif

3. Gather the database credentials

(Standard and Enterprise Edition only)

Make sure you have all account credentials, SQL database credentials, your SolarWinds account, and local admin server credentials. This includes:

  • Network path to the database instance
  • SQL Server database server hosting the Orion database (for an Orion Platform integration)

The local administrator account is not the same as a domain account with local admin rights. A domain account is subject to your domain group policies.

Last modified

Tags

Classifications

Public