Configuring Webtrends Services User Accounts

Instructions for configuring Webtrends services user accounts.

During installation of the Webtrends Analytics master database, you have the option of specifying a single user account (Typical option) to control the Loader Service group, the UI Service group, and the Master Database service group, or one account for each of the service groups (Advanced option). Before you install Webtrends, you need to create Active directory users for Webtrends services to run under.

If your organization does not have strict security requirements for applications that access Microsoft SQL Server 2008, you can select Typical to use one user for all three service groups. This simplifies installation and maintenance.

You can also create two or three users for the service groups to run under, using the Advanced option. See Table 1: Database Permissions for a list of database permissions assigned to each group. This information may help you decide how many users to create.

Note: Each Active Directory user must be a member of the local administration group and have permissions on all shared directories used by Webtrends on every computer in the distributed installation environment.

When you install Visitor Data Mart, the Webtrends installer creates SQL Server 2008 users associated with each of the domain user accounts you create before installation. Each SQL Server 2008 user is given only the minimum permissions to allow the associated service group to perform its tasks. For information about the SQL Server 2008 permissions assigned to each service group, see Table 1: Database Permissions.

Table 1. Database Permissions
Service Group	Application(s)	System (Master) Database	Configuration Database	Event Database
Loader Service	Event Database Loader Services	Server Roles: public	Server Roles: public, processadmin	Server Roles: public, processadmin, dbcreator
		Database Permissions: data reader, data writer, exec sproc	Database Permissions: data reader, data writer, exec sproc	Database Permissions: db_owner or db_ddladmin, db_securityadmin, db_accessadmin, data reader, data writer, execsproc NOTE: [msdb] requires the sqlAgentUserRole
UI Service	Tomcat service (for administration UI), User Interface Service	Server Roles: public	Server Roles: public	Server Roles: public
		Database Permissions: data reader, data writer, exec sproc	Database Permissions: data reader, data writer, exec sproc	Database Permissions: data reader, data writer, exec sproc
System Service	Scheduler Agent, System Monitor, Email Notification, Event Database Splitter, Log File Pre-processor	Server roles: public	Server roles: public	Server roles: none
		Database Permissions: data reader, data writer, exec sproc	Database Permissions: none	Database Permissions: db_ddladmin

Was this topic helpful? Send feedback.