Unable to login to Web Reports

Reporting
1

(imported topic written by chipjnr)

Hi,

It has been a while since I’ve used Web reports & I’m unable to logon.

How do i reset the Admin password to logon?

We are using bigFix version 7.0.1.376

Many thanks,

Neil

2

(imported comment written by Lee Wei)

Hi Neil,

If the USERS table in the BESReporting database is empty (as it would be when first installed), WebReports will prompt you for the first and administrative account.

Please see the following KB for more info:

http://support.bigfix.com/cgi-bin/kbdirect.pl?id=122

Lee Wei

3

(imported comment written by chipjnr)

Hi,

Thanks very much. Logged in now…

Neil

4

Here is the reset instructions since the link is broken

Local Web Reports Admin: If access to Web Reports as a local admin user has been lost somehow:

  1. Login to the BESReporting database in SQL
  2. Determine if the username for the user you would like to create is already taken (for example: bigfix)
    o select UserID from USER_NAMES where LoginName = 'bigfix’
    o select UserID from USERS where LoginName = ‘bigfix’
  3. If you want to delete this user ahead of recreating it, run the following delete queries:
    o delete from USERS where UserID =
    o delete from USER_NAMES where UserID =
    o delete from ROLE_USER_ASSIGNMENTS where UserID =
  4. Run the following query statement block to create the user (i.e. one named bigfix):
    begin
    declare @id int
    insert into USER_NAMES ( LoginName, DisplayName, IsADUser ) values ( ‘bigfix’, ‘bigfix’, 0 )
    set @id = (select UserID from user_names where LoginName = ‘bigfix’)
    insert into USERS ( UserID, LoginName, PasswordHash, PasswordSalt ) values ( @id, ‘bigfix’, ‘gwCOEwCUD1ntCnCBwRDV+VzdvvM’, ‘1’ )
    insert into ROLE_USER_ASSIGNMENTS ( UserID, RoleID ) values ( @id, 1 )
    end
    go
  5. You should now be able to login to Web Reports using:
    Username: bigfix
    Password: bigfix
2 Likes