Technical Library | Support

Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Troubleshooting > Log Server and Log Database issues > Configuring user permissions for Microsoft SQL Server
Configuring user permissions for Microsoft SQL Server
Web Security Help | Web Security Solutions | Version 7.8.x
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 Websense Log Server successfully, the user account that owns the Websense database must:
1.
Be a member of the dbcreator fixed server role.
2.
In the msdb database:
*
Have membership in the db_datareader role.
*
Have membership in one of the following roles:
*
SQLAgentUserRole
*
SQLAgentReader Role
*
SQLAgentOperator 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, go to Start > Programs > Microsoft SQL Server 2008 or 2012 > Microsoft SQL Server Management Studio.
2.
Select the Object Explorer tree, and then go to select Security > Logins.
3.
Select the login account to be used during the 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.

Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Troubleshooting > Log Server and Log Database issues > Configuring user permissions for Microsoft SQL Server
Copyright 2016 Forcepoint LLC. All rights reserved.