dcsimg

The previous login credentials display greyed out when migrating the system database

Products

Webtrends Analytics 9.x
Webtrends Analytics 8.7

Issue

When migrating the system database, or importing a client’s system database into a local installation, during the modified installation the login credentials from the previous installation appear greyed out and cannot be modified.

Resolution

This information is pulled from the [wtmaster].[dbo].[wt_ServiceGroup] table. Update it with the following query:

UPDATE [wtmaster].[dbo].[wt_ServiceGroup]
SET [ServiceLogin] = ‘<host>\<user>’;

Where <host> is the name of the host machine and <user> is the name of the user account.