Configure the SE-Viewer Database for Microsoft
SQL Express
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.
Operating Systems: Windows XP, Windows 7; Windows Server 2003;
Windows Vista ; Windows Server 2008; Windows Server 2008 R2
You must have administrative rights on the computer to install
SQL Server Express.
IIS 6.0 or later
Microsoft .NET Framework 2.0 or later
Microsoft SQL Server 2008 Express Edition
Operating Systems: Windows Server 2003 Service Pack 2; Windows
Server 2008; Windows Vista; Windows Vista Service Pack 1; Windows
XP Service Pack 2; Windows XP Service Pack 3; Windows 7; Windows
Server 2008 R2
You must have administrative rights on the computer to install
SQL Server Express.
IIS 6.0 or later (required only for Intercept products)
Microsoft SQL Server 2005 Express Edition with Advanced
Services Service Pack 3
(http://www.microsoft.com/downloads/details.aspx?FamilyID=b448b0d0-ee79-48f6-b50a-7c4f028c2e3d&DisplayLang=en)
or Microsoft SQL Server 2008 Express with Advanced Services
(http://www.microsoft.com/downloads/details.aspx?familyid=B5D1B8C3-FDA5-4508-B0D0-1311D670E336&displaylang=en)
It is strongly recommended to install MSSQL Express Edition 2008
(64-bit installer) on 64-bit environment, because MSSQL Express
2005 requires IIS to be run in 32-bit mode. Running IIS in 32-bit
mode on a 64-bit system requires additional system setup and can
affect existing web applications. If you still want to install
MSSQL Express Edition 2005 on 64-bit operation system please read
How to configure IIS to be run in 32-bit
mode for the appropriate instructions.
For 32-bit systems we recommend MSSQL Express Edition 2005.
Install MSSQL Express 2005 with Advanced
Services
Execute SQLEXRP_ADV.EXE
Accept the licensing terms and click Next
On the prerequisites screen, click Install
Wait until the prerequisites installation completes and click
Next
On the start screen of SQL Server Installer click Next
Ensure that all system requirements were passed and click
Next
On the Registration Information screen click Next
Select ‘Entire feature will be installed on local hard drive’
for both “Reporting Services” and “Client Components”. Click
Next
Select the “Mixed Mode”
radio-button and specify a strong password for the ‘sa’ account
(for example “cob0l*”). Click Next
Check ‘Add user to the SQL Server Administrator role’ checkbox
and click Next
Do not make changes on the ‘Error and Usage Report Settings’
screen and click Next
On the ‘Ready to Install’ screen click Install
Wait until the installation completes and click Next
On the ‘Summary screen’ click Finish. The installation has
completed.
Install MSSQL Express 2008 with Advanced
Services
Run either SQLEXPRADV_x64_ENU.exe or SQLEXPRADV_x86_ENU.exe,
depending on your operation system.
In the Installation Center window, select Installation from the options on the left, and
New SQL Server stand-alone installation or
add features to an existing installation
Wait for the setup rules to be checked. Ensure that setup rules
were verified and click OK
On the Product Key screen, click Next without any changes
Accept the License Terms and click Next
On the Setup Support Files step click Install
Wait until Support Files are installed. Click Next
On the Feature Selection step, click Select All and then Next
On the Instance Configuration step, click Next without any changes
Ensure that Disk Space Requirements were verified and click
Next
On the Server Configuration screen, click Use the same account for all SQL Server services
button. In the popup that appears, select NT AUTHORITY\NETWORK
SERVICE as the Account Name and click OK. Click Next on
the Server Configuration screen.
On the Database Engine Configuration screen select the
Mixed Mode radio button. Specify a
strong password for the built-in SQL Server system administrator
account (for example, “cob0l*”). Click Add
Current User. Click Next.
On the Reporting Services Configuration step, click
Next without any changes
On the Error and Usage Reporting step, click Next without any changes
Wait for the installation rules to be checked. Ensure that
installation rules were verified and click OK
On the Ready to Install step, click Install
Wait until the installation completes and click Next
MSSQL Express Edition 2005 requires IIS to be run in 32-bit
mode. To enable the 32-bit version of ASP.NET please complete the
steps described below depending on your IIS version. This operation
is not needed for MSSQL Express Edition 2008, because it has
installers for both 86x and 64x operation systems.
Enable the 32-bit version of Microsoft ASP.NET on the computer
with IIS 6
Enabling 32-bit
ASP.NET applies only to 64-bit environments
To enable the 32-bit version of ASP.NET:
Go to Start Run, type cmd, and then click OK.
Type the following command to enable 32-bit mode:
cscript
%SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET
W3SVC/AppPools/Enable32bitAppOnWin64 1
Type the following command to install the version of ASP.NET
2.0 (32-bit) and to install the script maps at the IIS root and
under:
Make sure that the status of ASP.NET version 2.0.50727 (32-bit)
is set to Allowed in the Web service extension list in Internet
Information Services Manager.
Enable the 32-bit version of Microsoft ASP.NET on the computer
with IIS 7
IIS7 Components Pre-requisites
If you do not
enable all of these features, the Reporting Services option will
not appear in the Feature Selection dialog box of the SQL Server
Setup program.
Expand Common HTTP Features, and then click to select the
following check boxes:
Static Content
Default Document
Directory Browsing
HTTP Errors
HTTP Redirection
Expand Application Development, and then click to select the
ASP.NET check box.
Expand Security, and then click to select the Windows
Authentication check box.
Expand Management Tools, expand IIS 6 Management Capability,
and then click to select the following check boxes:
IIS Metabase Compatibility
IIS 6 WMI Compatibility
IIS 6 Scripting Tools
IIS 6 Management Console
Verify that the World Wide Web Publishing service is started.
If the World Wide Web Publishing service is not started, configure
the service to start automatically. To do this, follow these
steps
In Control Panel, go to System and
MaintenanceAdministrative Tools Services
In the User Account Control (if UAC enabled) dialog box, click
Continue.
Right-click World Wide Web Publishing
Service, and then click Properties.
In the World Wide Web Publishing Service Properties dialog box,
select Automatic in the Startup type
list.
Click Apply, click Start, and then click OK.
IIS7 Configuration
Set the Enable32bitAppOnWin64 option to True at the Parent level
under the master Web site level. To do this, follow these
steps:
In IIS Manager, click Application
Pools.
In the Actions pane, click Set
Application Pool Defaults.
In the General section, set the Enable32bitAppOnWin64 option to True.
Last update: Thursday, December 09, 2010
11:39:48 AM
Enabling 32-bit
ASP.NET applies only to 64-bit environments
Run, type cmd, and then click OK.