Submit a ticketCall us

Announcing NPM 12.2
With NPM 12.2 you can monitor your Cisco ASA firewalls, to monitor VPN tunnels for basic visibility and troubleshooting tunnels. NPM 12.2 also uses the SolarWinds Orion Installer so you can easily install and upgrade one or more Orion Platform products simultaneously.
See new features and improvements.

Home > Success Center > Database Performance Analyzer (DPA) > Install and configure SQL Server Express for DPA repository

Install and configure SQL Server Express for DPA repository

Table of contents

Overview

This article provides steps to install and configure SQL Server Express for DPA repository.

Environment

  • All DPA versions
  • Microsoft SQL Server 2008, 2012, or 2014

Steps

Note: You can use the Express edition of Microsoft SQL Server 2008, 2012, or 2014 to host the repository database.

 

Example installation:

SQL Server 2008 Express  (SQLExpress) can be used to hold the repository database for a DPA trial. Because SQLExpress has a 4 GB storage limitation, SolarWinds recommends that you do not use SQL Server Express long term.

 

I. - Download and install SQL Server Express

  1. Download the SQL Server 2008 Express edition. Select the SQL Server 2008 Express with Tools option.
  2. Install by following the steps in the setup wizard.
  3. During the setup, you are prompted for Account Provisioning.
    1. Select the Mixed Mode (Both Sql Server & Windows authentication) option.
    2. Enter a password for the SA account.
    3. Click Add Current User, and enter the Domain\Administrator for the computer.
  4. Create a database instance. You can accept the default name, or click Named to change the name.
  5. Note the database name to use later in DPA. Continue the setup wizard.

 

II. - Configure SQL Server Express

  1. From the Microsoft SQL Server 2008 program folder, click Configuration Tools > SQL Server Configuration Manager.
  2. Expand SQL Server Network Configuration" > Protocols for your instance.
  3. Under Protocol Name, right-click TCP/IP, and click Properties.
  4. Select Yes in the Enabled list.
  5. Click the IP Addresses tab.
  6. Select Yes for the Enabled value of each IP Address.
  7. Under IP1 and IP2, enter 1433 for the TCP Port. You can use another port number, but 1433 is the default port for SQL Server.
  8. Under IPALL, enter a different port, such as 1444. Note both port numbers to use later in DPA.

 

III. - Start the SQL Server service

  1. In the SQL Server Configuration Manager, open SQL Server Services.
  2. Right-click your SQL Server instance, and click Properties.
  3. Click Start.
  4. You may also want to start the SQL Server Browser. Start the SQL Server Browser to connect with both IPs using the 1433 port as well as going directly to the IPALL port of 1444. This is explained below in more detail.

 

IV. - DPA configuration

  1. Install DPA, and load the setup wizard in a browser.
  2. Select SQL Server as the repository database type.
  3. Enter the following connection information:
    1. Enter the SA credentials that you set up when you created the SQL Server Instance.
    2. If you enabled the SQL Server Browser service, enter the host\name if you named your instance, or host\SQLEXPRESS if you chose the default .
    3. Enter 1433 in the Port field.
    4. If the SQL Server Brower is not running, you must enter only the hostname in the Server field, and the IPALL port (1444 in this example) in the Port field.
  4. Click Next to continue.
  5. After the repository is created, you can monitor your other databases.
Last modified
19:14, 22 Jun 2016

Tags

Classifications

Public