Submit a ticketCall us
Home > Success Center > Archive > 2018July09 - Deletes > Install and configure SQL Server 2008 Express for DPA repository

Install and configure SQL Server 2008 Express for DPA repository

Table of contents
No headers
This article is slated for Deletion. Do not update this article. If you have questions please send a message to

Created by Interspire Import, last modified by Gerald.Prado on Jul 09, 2018

Views: 1,201 Votes: 0 Revisions: 8

SQL Server 2008 Express Installation:

SQL Server 2008 Express  (SQLExpress) can be used to hold DPA's repository database when trialing DPA software.  Due to SQLExpress's 4 gigabyte storage limitation, it may not be suitable for long term DPA monitoring, especially when monitoring many database instances.


To install, download the SQL Server 2008 Express Edition from Microsoft: (© 2017 Microsoft, available at, obtained on November 16, 2017).


Choose the 'SQL Server 2008 Express with Tools' option listed in the example below:

Screenshots property of ©2017 Microsoft.


Install the software by following the steps listed in the setup wizard:


During the setup, you will be prompted for Account Provisioning. Select the "Mixed Mode (Both SQL Server & Windows authentication)" feature and enter a password for the 'SA' account.  At the bottom of the screen, select  "Add Current User" and enter the Machine(Domain)\Administrator for the machine. See example below.


You will also be prompted for creation of a Database Instance. You can either take the "Default" SQLExpress name or specify a name for the instance by choosing the "Named" button, then enter the name for your Instance.  You will want to remember which setting you chose for connecting to the Instance for later DPA configuration. Continue following through the Setup wizard until it has completed successfully.


Once SQLExpress is installed, go to the Start menu and bring up the Server Configuration Manager:


 In the Configuration Manager, you will need to enable TCP/IP, so DPA can connect to the Instance. Choose "SQL Server Network Configuration" > "Protocols For your instance" > TCP/IP  > right-click - choose Properties > Change the "Enabled " to "YES" and apply your changes.  The example below shows how to enable TCP/IP for the "named" instance, SE12008.


Choose the "IP Addresses" tab on the TCP/IP properties screen and enable all of the IP Addresses listed on the screen by changing the "No" to a "Yes" for the "Enabled" column. Also, fill out the "TCP Port" entry for all the real IP Addresses by entering 1433 (you can use another port number here, but 1433 is typically the default port for SQL Server). In the "IPALL" section, enter a different port, such as 1444 in the example below. You will need to know both the IP port number as well as the IPALL port number for DPA's configuration.


Once you've changed the TCP/IP settings, you will need to stop / start the SQL Server service for the Database Instance you created. In the Configuration Manager, open the SQL Server Services tab, highlight your SQL server instance, then right click for the properties tab to stop / start the instance.  See example below.  You may also want to stop / start the SQL Server Browser at this time, as well.  Starting the SQL Server Browser allows you to connect with both IPs using the 1433 port as well as going directly to the IPALL port of 1444. This will be further explained below in the DPA configuration section.


Congratulations!  If you've made to this step, you now have a fully installed and running Instance of  SQL Server 2008 Express!

DPA's Configuration:

You are now ready to download and install DPA. Once  you've installed DPA's software, you will be prompted to bring up DPA's Setup Wizard in a browser. The wizard will prompt you for which database type to build the DPA repository in. Choose SQL Server database type, and then enter the connection criteria as explained below:

Enter the "SA" account/password  that you set up when you created the SQL Server Instance.  If you enabled the SQL SERVER Browser service, then enter the host\name if you named your instance, or host\SQLEXPRESS if you chose the "default" in the Server field.  Then, enter the 1433 port in the Port field. 


 If you do not have the SQL SERVER Brower running, you will need to enter the host name only in the Server field and the IPALL port address  (for example,1444) in the Port field.


DPA will test the connections and then proceed with prompting you for the Repository Owner / Password, files name / location and then build the repository. Once the repository is created, you can begin setting up monitoring for your other databases.


If you have any issues with these instructions or installing DPA, please contact SolarWinds Support


Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.  You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.


Last modified


This page has no custom tags.


Internal Use Only