How to create the wtEtlCredential account and configure the wtEtl application proxy


Webtrends Visitor Data Mart


The wtEtlCredential account is missing or incorrectly configured, causing problems with the lookup table/translation file import process and configured extended attributes databases.


If the “wtEtlCredential” SQL Server credential is missing on the EDB (shown below), or the password for the account that is used in the credential has changed. The user will have to update it per the instructions below.

wtEtlCredential shown in SQL Server Management Studio

User-added image
If the credential is missing, you could add it back via SQL Server Management Studio (shown below):

User-added image

Or, you could add the credential back via the following SQL Script:

CREATE CREDENTIAL [wtEtlCredential] WITH IDENTITY = N’TheLoaderServiceAccount’, SECRET = N’PasswordForAccount’

If the credential exists, but you are still getting the error you may need to update the password. You can update the password via SQL Server Management Studio.

A couple of other things you may want to validate:
SQL Server Agent must be running on that EDB server.
The following SQL Server Proxy account must exist on that server: ?wtEtl application proxy?

User-added image

If the proxy account is missing, you?ll have to add it back.
o Using SQL Server Management Studio:
User-added image

o Via Script:
USE [msdb]
EXEC msdb.dbo.sp_add_proxy @proxy_name=N’wtEtl application proxy’,@credential_name=N’wtEtlCredential’,
@description=N’WebTrends ETL execute SSIS package proxy.’
EXEC msdb.dbo.sp_grant_proxy_to_subsystem @proxy_name=N’wtEtl application proxy’, @subsystem_id=11