Custom Deployment > Installing SQL Server 2008 R2 Express (without TRITON Infrastructure)

Installing SQL Server 2008 R2 Express (without TRITON Infrastructure)

Applies to

Web Filter v7.6

Web Security v7.6

Web Security Gateway v7.6

Web Security Gateway Anywhere v7.6

Data Security v7.6

Email Security Gateway v7.6

Email Security Gateway Anywhere v7.6

Installing SQL Server 2008 R2 Express

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 Web Security 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.

3.	If you currently use MSDE for Websense data and want to use that data post-upgrade, back up the Websense databases now. See Backing up Websense data from MSDE for instructions. Leave the Websense installer running and come back once you have backed up MSDE data.

You may have to stop Filtering Service now. 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.

4.	It is assumed you have already launched the the Websense installer and chosen the Custom installation type. If not, see Custom Installation.

You may also be following these instructions as part of upgrading (Web Security) Log Server to version 7.6. If so, skip this step. Also note that instead of the Custom Installation dashboard, you may be in the Modify Installation dashboard. The steps to complete remain the same.

5.	On the Custom Installation dashboard, click the Install link for SQL Server Express.

6.	On the Welcome screen, click Start to begin the installation wizard.

7.	On the Configuration screen, selection 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:

Note  If MSDE is currently installed on this machine, you must install SQL Server Express to a named instance. It is a best practice to name the instance TRITONSQL2K8R2X. Other upgrade instructions regarding moving Websense data from MSDE to SQL Server Express will assume this instance name if both are installed on the same machine. If you choose a different one, substitute the instance name accordingly when following those instructions.

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.

8.	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.

9.	Next, the Installation screen appears. Wait until all files have been installed.

10.	On the Summary screen, click Finish.

11.	If you backed up Websense data from MSDE:

a.	Make sure TCP/IP connection to the database instance is enabled and SQL Server Browser service is running.

See SQL Server 2008 R2 Express for instructions.

b.	Restore the backed up data to SQL Server Express.

See Restoring Websense data to SQL Server Express for instructions.

c.	Configure Log Server to use the installation of SQL Server Express.

See Configuring 7.5 Log Server to SQL Server Express prior to upgrade to 7.6 for instructions.

This must be done or the Websense installer will be unable to upgrade Log Server to version 7.6. Note that Log Server may be running on a different machine.

Custom Deployment > Installing SQL Server 2008 R2 Express (without TRITON Infrastructure)