Submit a ticketCall us

Welcome to the NEW Success Center. Search all resources (documentation, videos, training, knowledge base articles) or browse resources by product. If you are unable to find what you are looking for, please contact us at customersuccess@solarwinds.com

 

 

 

 

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