Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

Home > Success Center > Database Performance Analyzer (DPA) > 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
Created by Interspire Import, last modified by Melanie Boyd on Nov 16, 2017

Views: 78 Votes: 0 Revisions: 7

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: www.microsoft.com/express/sql/download (© 2017 Microsoft, available at https://www.microsoft.com, obtained on November 16, 2017).

 

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

Screenshots property of ©2017 Microsoft.

ss8.jpg

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

ss7.jpg

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.

ss6.jpg

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:

ss5.jpg

 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.

ss4(1).jpg

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.

ss3.jpg

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.

ss0.jpg

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

Tags

Classifications

Public