Installing with SQL Server

Applies to

Web Filter v7.6

Web Security v7.6

Web Security Gateway v7.6

Web Security Gateway Anywhere v7.6

Installing with SQL Server

See System Requirements for which versions of SQL Server are supported.

1.	Install SQL Server according to Microsoft instructions, if needed.

2.	Make sure SQL Server is running.

3.	Make sure SQL Server Agent is running.

Note  On SQL Server 2008 Express R2, SQL Service Broker is used instead of SQL Server Agent.

4.	Obtain the SQL Server logon ID and password for a SQL Server Administrator, or for an account that has db_creator server role, SQLAgent role, and db_datareader in msdb.

You need this logon ID and password when you install Websense components.

5.	Restart the SQL Server machine after installation.

Note  You must restart the machine after installing Microsoft SQL Server and before installing Websense Web Security Log Server or Email Security Log Server.

6.	Make sure the TRITON Unified Security Center machine can recognize and communicate with SQL Server.

If Web Security Log Server or Email Security Log Server are installed on another machine, make sure it can communicate with SQL Server as well.

7.	Install the SQL Server client tools on the TRITON Unified Security Center machine. Run the SQL Server installation program, and select Connectivity Only when asked what components to install.

If Web Security Log Server or Email Security Log Server is installed on another machine, install the SQL Server client tools on that machine instead.

8.	Restart the machine after installing the connectivity option. See Microsoft SQL Server documentation for details.

Configuring Microsoft SQL Server user roles

Microsoft SQL Server defines SQL Server Agent roles that govern accessibility of the job framework. The SQL Server Agent jobs are stored in the SQL Server msdb database.

To install Websense Log Server successfully, the user account that owns the Websense database must have one of the following membership roles in the msdb database and db_datareader :

SQLAgentUserRole

SQLAgentReader Role

SQLAgentOperator Role

The SQL user account must also have dbcreator fixed server role privilege.

Use Microsoft SQL Server Management Studio to grant the database user account the necessary permissions to successfully install Log Server.

1.	On the SQL Server machine, go to Start > Programs > Microsoft SQL Server 2005 or 2008 > Microsoft SQL Server Management Studio.

2.	Log into SQL Server as a user with SQL sysadmin right.

3.	Select the Object Explorer tree, and then go to select Security > Logins.

4.	Select the login account to be used during the installation.

5.	Right-click the login account and select Properties for this user.

6.	Select Server Roles, and then select dbcreator.

7.	Select User Mapping and do the following:

a.	Select msdb in database mapping.

b.	Grant membership to one of these roles:

SQLAgentUserRole

SQLAgentReader Role

SQLAgentOperator Role

db_datareader

c.	Click OK to save your changes.

8.	Click OK to save your changes.