Configure the SE-Viewer Database for SQL Server

Using the Configuration Utility

All events are written to a Microsoft SQL Server or Microsoft SQL Express database. For use in a production environment, AVIcode recommends configuring the system to use a SQL Server database.

The Configuration Utility is a tool that allows you to automatically create and/or configure the following components:

Create a new SE-Viewer database and grant the necessary rights
Create a new Advisor database and grant the necessary rights
Configure the connection to the SQL Server Reporting Services (SS RS) service

In some cases the Configuration Utility cannot complete all of the necessary configuration steps automatically due to a lack of MS SQL server administrative rights. Additionally, if you use the Windows Integrated security model, you will have to manually configure the IIS Application pool and Intercept Reporting Windows Service to be run under a custom Domain account.

Later in this chapter you will find step-by-step instructions that allow you to complete the configuration process. Most of steps apply to any installation, but certain steps are only needed for certain configuration scenarios. You will need to be able to answer these questions:

Will you use the Windows NT Integrated Security model?
Can you run the Configuration Utility under an account that has MS SQL server Administrative rights?
If you are using SQL Authentication mode, aan you specify a SQL account with Administrative rights during the database configuration process?

Configuring the SE-Viewer Database for MS SQL

The SE-Viewer Configuration Utility allows you to manage the SE-Viewer database:

Create a database new login or modify an existing login
Create the database
Bind the user login to the new database
Automatically detect the current database version and upgrade it
Execute custom scripts
Execute tuning scripts

The database requires a minimum 10 GB of free space

New Installations

Custom Security

The first step to prepare your environment is to identify the server on which you will install the SE-Viewer database. Once this is determined, create and configure the database.

Install Microsoft SQL Server on appropriate server.
Open the SE-Viewer Configuration Utility

Go to the 'SE-Viewer database' tab
From the 'Data Manager' dropdown, select 'MS SQL Server'
In the 'Server Name' text field, enter the DNS hostname of the SQL server
Select Use a specific user name and password
Fill in the appropriate data in the 'User name' and 'Password' fields
We do not recommend making changes to the 'Additional Parameters' text field
Click Test
For a new database, an error message will appear that says the database and user account are not configured properly. Click Yes to configure the database.

If the test succeeds, then your database has already been configured and you do not need to continue with these instructions.

When the popup window appears, click Connect to ensure that the administrative account for the database is correct. Make corrections as necessary until the connection works.
Click Execute to initialize the tables in the database. The status of the initialization process will appear at the bottom of the window. You can also click on the 'Script' link on the 'Create Database' line to view the initialization script that will be used.

Modifications can be made to the script and the script saved via Save As

Click Close when the initialization completes.

Windows Security

The first step to prepare your environment is to identify the server on which you will install the SE-Viewer database. Once this is determined, create and configure the database.

Install Microsoft SQL Server on appropriate server.
Select a service account to use

This account should have:

“Read” and “Read & Execute” access to [SEVIEWERINSTALLDIR] folder and all subfolders
“Full” access to [SEVIEWERINSTALLDIR]\Database folder and all subfolders
“Full” access to [SEVIEWERINSTALLDIR]\Reporting folder

Open 'Administrative Tools''Computer Management'
Add the service account to the appropriate IIS group (depending on the version of Windows being used)
Open IIS
Configure the application pool being used by Intercept Studio to use the service account
Open the SE-Viewer Configuration Utility

Go to the 'SE-Viewer database' tab
From the 'Data Manager' dropdown, select 'MS SQL Server'
In the 'Server Name' text field, enter the DNS hostname of the SQL server
Select Use Windows NT Integrated security

NT security mode (Windows NT Authentication only) vs. Mixed mode (Windows NT Authentication and SQL Server Authentication).

In Windows NT mode (the 'Use Windows NT Integrated security' option), users that NT validates can also connect to SQL Server databases based on their user account names and group membership which already exist in Windows NT 4.0, or Windows XP.

In mixed mode ('the Use a specific user name and password' option), NT users connect to SQL Server databases under Windows NT mode and users that NT doesn't validate use valid SQL Server (SQL Server Authentication) logins. Users that connect to SQL Server databases under Windows NT can make use of trusted connection mechanism for both authentication modes. Whenever the SQL Server database is connected, the access control mechanisms that in this case are lower level-ones (access to databases or database objects only) function identically in both authentication modes.

We do not recommend making changes to the 'Additional Parameters' text field
Click Test
For a new database, an error message will appear that says the database and user account are not configured properly. Click Yes to configure the database.

If the test succeeds, then your database has already been configured and you do not need to continue with these instructions.

When the popup window appears, click Connect to ensure that the administrative account for the database is correct. Make corrections as necessary until the connection works.
Click Execute to initialize the tables in the database. The status of the initialization process will appear at the bottom of the window. You can also click on the 'Script' link on the 'Create Database' line to view the initialization script that will be used.

Modifications can be made to the script and the script saved via Save As

Click Close when the initialization completes.
Go to the SQL Server and open SQL Server Manager
Configure permissions for the service account for the SE-Viewer database, ensuring that the user associated with the login and password has public, db_datareader and db_datawriter permissions.

Upgrading

Use Microsoft SQL Server Enterprise Manager to navigate to the server that contains the Intercept Studio 'seviewer' database. (The path to the server and database name are in the database connection string from the 'SEViewer.config' file)
Use Enterprise Manager to back-up the 'seviewer' database.
Open the SE-Viewer Configuration Utility

Go to the 'SE-Viewer database' tab
The popup window will be filled in with your current database information
Click Test
An error message will appear that prompts you to upgrade the database. Click Yes to configure the database.

If the test succeeds, then your database has already been configured and you do not need to continue with these instructions

When the popup window appears, click Connect to ensure that the administrative account for the database is correct. Make corrections as necessary until the connection works.
Click Execute to upgrade the tables in the database. The status of the initialization process will appear at the bottom of the window.
Click Close when the upgrade completes.

Last update: Thursday, December 09, 2010 02:07:47 PM