Products
Webtrends Analytics 8.5
Cause
If an administrator of a Webtrends installation is unable to log into their administrator account and there are either no other administrators available or no other administrator accounts on the system.Resolution
Execute the script in the next section to create an administrator-level account with the user name “wtsupport” and the password “admin”.Perform the following steps before running the script:
1. Stop all Webtrends services except the “SQL Server (MSSQLSERVER)” service.
2. Back up the MS SQL database.
3. Examine the wt_user table in the wtmaster database. Make note of the last number used in the “UserID” column.
4. Replace each occurrence of “999” in the script to be the next incremented value from the current UserID value from step 4.
Execute the queries in the script, then log in and confirm the application is accessible with administrative rights.
It is recommended the user changes the account user name and password immediately after logging in.
More Information
use wtmaster set identity_insert wtMaster.dbo.wt_User on go INSERT INTO dbo.wt_User (UserID, LoginAccountID, UserName, Email, Password, FirstName, LastName, Company, PhoneNumber, ReceiveNewsletter, ReceivePartnerOffers, AllOptOut, LastPasswordChangeTime, CreateTime, ValidationKey, Validated, LastPasswordChange, IsDemoUser, PasswordType, RoleID, LastLoginTime, HideConsolePages, IsSystem, TimeZone, SessionTimeout, AcceptedEULA, UserStatusID, CurrentFailedLoginCount, ActiveDirectoryDomain, ActiveDirectoryUserName, ActiveDirectoryExtendedAuth, UILocale, UILanguage, HasWTDSAccess, RoleUserID, IsRole) VALUES ('999', '1', 'wtsupport', '', 'D9723F0CD2C107AB1DCC142197C94B1101AB', 'webtrends', 'tempuser', 'webtrends', 'False', 'False', '0', 'True', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'False', GETDATE(), 'False', 'wt', '999', NULL, '0', '0', NULL, '60', 'False', '1', '0', NULL, NULL, NULL, NULL, NULL, 'False', '1', 'False'); INSERT INTO [dbo].[wt_userrighttokenmap] VALUES('999', 'SuperAdmin', '1', '0');