How to retain passwords for transferred users


Webtrends Analytics 9.x
Webtrends Analytics 8.x


A client wanted to transfer or copy users from one install to another. Since this isn’t possible, they would have had to create new users in the new install. In many of these cases, there are multiple users using Webtrends authentication. Since users aren’t able to change their own passwords, it’s preferred that they retain their passwords.


Webtrends uses the same encryption key regardless of install and version. Because of this, the encrypted password from the original install can be copied into the new install once the users are created. This information is always stored in the wt_user table of the wtmaster database. The field name is Password.

There is no script for this.

Preferably the client is able to bring up SQLYog or SQL Management Studio for both installs and copy paste between them. If they don’t have this capability, they would need to copy the user IDs and passwords into a text file or Excel and then bring that to the new machine. On the new machine, they would then need to use SQLYog or SQL Management Studio to paste the encrypted passwords into the database.

This is NOT a supported Webtrends method and should only be used if absolutely necessary.

More Information

For more information please see the article titled: How do I copy a user account from one Webtrends installation to another?