Documentation | Support

Go to the table of contents Go to the previous page You are at the end of the document View or print as PDF
Log Server Troubleshooting Guide : Log Database permissions
Log Database permissions
Forcepoint Web Security and Forcepoint URL Filtering, v8.4.x, v8.5.x | 29-Apr-2022
Microsoft SQL Server Standard and Enterprise editions define 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 Log Server successfully, the user account that owns the web protection database must have adequate permissions to create the Log Database. This account then becomes database owner.
If you are using Microsoft SQL Server 2008, 2008 R2, 2012, 2014, or 2016 Standard or Enterprise, the database owner account must:
1.
Be a member of the dbcreator fixed server role.
2.
Have membership in one of the following roles in the msdb database:
*
SQLAgentUserRole
*
SQLAgentReaderRole
*
SQLAgentOperatorRole
*
Have membership in the db_datareader role
For SQL Server Express, the account requires the sysadmin server role.
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, launch SQL Server Management Studio.
2.
Select the Object Explorer tree, and then select Security > Logins.
3.
Select the login account to be used during Log Server installation.
4.
Right-click the login account and select Properties for this user.
5.
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
c.
Grant membership to the db_datareader role.
d.
Click OK to save your changes.
6.
Select Server Roles, and then select dbcreator. The dbcreator role is created.
7.
Click OK to save your changes.
 
 
 
 
 
 
 
©2022 Forcepoint. Forcepoint and the FORCEPOINT logo are trademarks of Forcepoint. All other trademarks used in this document are the property of their respective owners.

Go to the table of contents Go to the previous page You are at the end of the document View or print as PDF
Log Server Troubleshooting Guide : Log Database permissions
Copyright 2022 Forcepoint. All rights reserved.