Technical Library | Support

Go to the table of contents Go to the previous page Go to the next page
Installing components via the Custom option > Installing SQL Server 2008 R2 Express (without TRITON Infrastructure)
Installing SQL Server 2008 R2 Express (without TRITON Infrastructure)
Deployment and Installation Center | Web, Data, and Email Protection Solutions | v8.0.x
Applies to:                                         
*
TRITON AP-WEB and Web Filter & Security, v8.0.x
*
TRITON AP-DATA, v8.0.x
*
TRITON AP-EMAIL, v8.0.x
During TRITON Infrastructure installation, you can choose to install SQL Server 2008 R2 Express along with it. If you are installing TRITON Infrastructure, and you want to install SQL Server 2008 R2 Express on the same machine (i.e., the TRITON management server) you should do so during TRITON Infrastructure installation. See Installing TRITON Infrastructure.
This section provides instructions for installing SQL Server 2008 R2 Express without installing TRITON Infrastructure. Typically, this is done to install SQL Server 2008 R2 Express on a machine that is not a TRITON management server.
1.
If you will use SQL Server 2008 R2 Express to store and maintain reporting data, log in to the machine as domain user. Do this prior to starting the Websense installer.
2.
It is a best practice to install the Windows prerequisites for installing SQL Server Express beforehand:
*
.NET Framework 3.5 SP1
*
Powershell 1.0
*
Windows Installer 4.5
 
* 
Note 
The Websense installer will automatically install these if not found on the machine.
See SQL Server 2008 R2 Express.
You may have to stop Filtering Service. If .NET 3.5 SP1 is not found on this machine, the installer needs access to windowsupdate.microsoft.com. If Filtering Service blocks this machine from accessing windowsupdate.microsoft.com, SQL Server Express cannot be installed.
3.
It is assumed you have already launched the the Websense installer and chosen the Custom installation type. If not, see Starting a custom installation (Windows).
4.
On the Custom Installation dashboard, click the Install link for SQL Server Express.
5.
On the Welcome screen, click Start to begin the installation wizard.
6.
On the Configuration screen, select options as described below and then click Next.
*
Use the Browse button to specify a different folder if you do not want to install to the default location shown.
*
If you want to create a named instance, instead of using the default SQL Server instance, select Named instance and then enter an instance name. Note the following about instance names:
*
Not case sensitive
*
16 characters or less
*
Only letters, numbers, dollar sign ($), or underscore (_) are allowed
*
First character must be a letter
*
Cannot contain the term Default or other reserved keyword (see Microsoft documentation for more information about reserved keywords)
*
Select an authentication mode:
*
Windows Authentication mode: select this to use Windows authentication, i.e., trusted connection, to authenticate users.
*
Mixed Mode (SQL Server authentication and Windows authentication): select this to use SQL Server authentication. Enter a password (and re-enter to confirm) for the built-in SA user.
Depending on your selections, the Pre-Installation Summary screen, will show different information than shown in the above illustration.
 
* 
Warning 
Depending on whether certain Windows prerequisites are installed, your machine may be automatically restarted up to two times during the installation process. Restarts are not required if the prerequisites are already installed.
7.
In the Pre-Installation Summary screen, click Next to begin installation.
The Setup Support Files screen appears and then an Installation Progress screen appears. Wait for these screens to complete automatically. It is not necessary to click or select anything in these screens.
Note that it may take approximately 10-15 minutes for the SQL Server 2008 R2 Express installation to complete.
8.
Next, the Installation screen appears. Wait until all files have been installed.
9.
On the Summary screen, click Finish.

Go to the table of contents Go to the previous page Go to the next page
Installing components via the Custom option > Installing SQL Server 2008 R2 Express (without TRITON Infrastructure)
Copyright 2016 Forcepoint LLC. All rights reserved.