Technical Library | Support

Go to the table of contents Go to the previous page Go to the next page
Deployment and Installation Center > Installing the reporting database in a custom folder with SQL Server 2012
Installing the reporting database in a custom folder with SQL Server 2012
Deployment and Installation Center | Web, Data, and Email Security Solutions | Version 7.8.x
Applies to:                                         
*
Web Filter, Web Security, Web Security Gateway, and Web Security Gateway Anywhere, v7.8.x
*
Data Security, v7.8.x
*
Email Security Gateway and Email Security Gateway Anywhere, v7.8.x
Starting with Microsoft SQL Server 2012, the database engine service must have access permissions for the folder where database files are stored. This affects the:
*
Web Security Log Database
*
Data Security Incident and Configuration Database
*
Email Security Log Database
If you want to store your reporting database or databases in any folder other than the SQL Server default folder (C:\Program Files\Microsoft SQL Server), you must:
1.
Create the custom folder.
2.
Grant the database engine service full permissions to the custom folder.
3.
Install your TRITON management server and (for Web or Email Security) Log Server components.
If you do not grant the database engine service the necessary permissions, the installer will not be able to create the reporting database or databases, and some components may fail to install, or be installed incorrectly.
To grant the proper permissions to the database engine service:
1.
In Windows Explorer, right-click the custom folder that you created to hold the reporting database or databases and select Properties.
2.
On the Security tab, click Edit, then Add.
3.
Make sure the hostname of the SQL Server machine appears in the "From this location" field of the Select Users... dialog box.
If the correct host is not selected, click Locations, then select SQL Server host machine and click OK.
4.
In the Enter the object names... text box, enter the SID of the SQL Server service:
*
The default instance SID is NT SERVICE\MSSQLSERVER.
*
Use the format NT SERVICE\MSSQL$InstanceName for a named instance.
5.
Click Check Names to validate the SID.
If the validation fails:
a.
Click OK in the pop-up box to open the Multiple Names Found dialog box.
b.
Select the correct SID, then click OK.
c.
Click OK again to return to the Permissions dialog box.
6.
In the Group or user names list, select the SID you just added, then mark the Allow check box under Full control in the Permissions list.
7.
Click Apply, and then click OK twice to exit.

Go to the table of contents Go to the previous page Go to the next page
Deployment and Installation Center > Installing the reporting database in a custom folder with SQL Server 2012
Copyright 2016 Forcepoint LLC. All rights reserved.