Products
Webtrends Analytics 9.x
Webtrends Analytics 8.x
Cause
The WebTrends Service Account needs to be changed, or updated. Some corporation policies change, or mandate, management of the service accounts in their environments.
Resolution
The permissions for the wtmaster and wt_sched databases, along with the service group table must be changed. The logon for each of the services must be updated with the new password, in addition to updating the password for the Application Pool in IIS.
Database user permissions
1. Bring down all of the nodes except for the main WebTrends Server
2. Stop all WebTrends services – leave SQL DB service running
3. Go into MS SQL Management Studio and perform the following:
a. add the new account under Security > Logins
b. Right click and select properties of that user
c. Under Server Roles, select ?public? and ?sysadmin?
d. Under User Mappings, select wt_sched and check db_owner
e. Select wtmaster and check db_owner
4. Edit the wtmaster table dbo.wt_Servicegroup ? Servicelogin and DatabaseUser to match new service user account
5. Close into MS SQL Management Studio
Services password update:
1. Open the Services snap-in.
2. Right-click on the service and select Properties.
3. Select the Log On tab.
4. Update the password in the “This Account” section.
5. Confirm the password.
Application Pool password update:
For IIS 5/6
1. Open Internet Information Services (IIS) Manager and expand Application Pools.
2. Right-click WebTrends Application Pool, then click Properties.
3. Click the Identity tab/section (depending on the version of IIS being used).
4. Update the password in the Password field.
5. Confirm the password.
For IIS 7
1. Open Internet Information Services (IIS) Manager and expand Application Pools.
2. Right-click WebTrends Application Pool, then click Advanced Settings.
3. Under the section Process Model, select Identity and click the browse (…) button.
4. Click Set.
5. Enter the User name and Password then click OK
After completing the above steps, restart SQL service and start all WebTrends services. Verify Webtrends is able to log in, view reports, and analyze. Then bring up each node separately and modify the Windows WebTrends services to reflect new service account