Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

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 MindTouch on Jun 23, 2016

Views: 61 Votes: 0 Revisions: 6

SQL Server 2008 Express Installation:

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

To install, download the Sql Server 2008 Express Edition from Microsoft: www.microsoft.com/express/sql/download   Choose the 'SQL Server 2008 Express with Tools' option listed in the example below:

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 Ignite 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 Ignite 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, however, 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 Ignite'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 Ignite's 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!

Ignite's Configuration:

You are now ready to download and install Ignite.  Once  you've installed Ignite's software, you will be prompted to bring up Ignite's Setup Wizard in a browser, (e.g. Internet Explorer or Firefox).  The wizard will prompt you for which database type (Oracle or SQL Server) to build the PI 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.  See below:

 ss2.jpg

 

 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  (1444 in the example below) in the Port field.

ss1.jpg

Ignite 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 Ignite, please email support@confio.com with the errors that you are encountering.  Confio Support will gladly assist you.

Last modified
19:14, 22 Jun 2016

Tags

Classifications

Public