Unable to launch IBM BigFix Administration Tool

[ani1214]

Dears,

When we launch the IBM BigFix Administration Tool on the BigFix Server(Windows), it prompts for the Site Admin Private Key…after entering the password…it prompts as follows:

Database: bfenterprise (Only option available in the list)
Username: sa (cannot be changed)
Password: xxxxxxx (we tried with all the passwords, but could not log in)

We are using Remote instance of SQL database, it is a consolidated database with Username as "bigfixadmin"
We tried using the password for the above Username, still unable to connect.

Could you please assist me??

[vnovik]

Hello ani1214,

This answer from Steve might help you:

IEM Application Admin tool issue

How BESAdmin and other services connect to the db is based on your ODBC definition. Check in ODBC Admin (odbcad32.exe) how the bes_bfenterprise System DSN is configured. If you want to use NT Authentication to connect as the user running the services/BESAdmin, then configure the DSN as such. Right now it is configured to use SQL authentication, so BESAdmin will prompt you to login as ‘sa’ and the other BES services will expect SQL credentials to be stored in the registry.

Please note the following KB article for changing a default username from sa to a custom name:
http://www-01.ibm.com/support/docview.wss?uid=swg21666274

Also it might be helpful to install SQL Management Studio on a BES Server box, configure it to connect to the remote DB using the same settings as BES Server and try to connect to that DB.

Regards,
Vitaliy

[ani1214]

Dear Vitaliy,

As per the document, I tried adding the DWORD, but still it reflects the same.

Is there any other workaround?

[vnovik]

Hello ani1214,

Which user was selected for the DB connection during the Server install?
Is this a new (just installed) deployment?
Is Server able to connect to the remote DB?
Was BESAdmin able to connect to the remote DB previously?

Before trying a custom user we might need to make sure that DB connection works for sa (or for another user selected for the DB connection during the Server install).

Also please be sure that the database username you are planning on using has sa level rights to the database. And specifically DBO rights to the BFEnterprise database.

Regards,
Vitaliy

[ani1214]

Which user was selected for the DB connection during the Server install?
-We created a username as “bigfixadmin” under dbcluster "DBCONxxxx"
Is this a new (just installed) deployment?
-its been few days installed
Is Server able to connect to the remote DB?
-Yes
Was BESAdmin able to connect to the remote DB previously?
-No
Before trying a custom user we might need to make sure that DB connection works for sa (or for another user selected for the DB connection during the Server install).

Also please be sure that the database username you are planning on using has sa level rights to the database. And specifically DBO rights to the BFEnterprise database.
-Yes, the SQL team has given DBO rights to the database, but, the database name is “DBCONxxxx” instead of “BFEnterprise”

[JasonWalker]

You should probably open a PMR with the support team, they may need to do a remote session to figure out your configuration.

Is BESAdmin allowing you to change the logon jame off of “sa” now that you’ve added the registry key? If not, the path or key name may not have been entered correctly.

Is BESAdmin still reflecting the wrong database name? I’m not sure, but I think besadmin also uses ODBC so be sure to check that both 32- and 64-bit ODBC connections are using the correct remote database name. You can check via c:\windows\system32\odbcad32.exe and c:\windows\syswow64\odbcad32.exe

[ani1214]

Thanks a lot for your response Jason. I will definitely check the ODBC connections for remote database name.

[Pogi]

Hi Ani1214,

As per Vitaliy, the document is proven and works fine with us. In the REGEDIT > HKEY_CURRENT_USER > SOFTWARE > Bigfix > BFEAdmin > Settings. Create the “AllowCustomUsername” in “Reg_DWORD” type with a value of 0x00000001 (1).

Hope this help.

[melissro]

Hello,

We have the same issue. The Admin Console keep asking for credentials and is Not allowing to change the User ID for the database login. So far we had:

• Changed all of the ODBC 64/32 that Big Fix created with the correct Database Credentials (w Successful Test to the DB Server)
• Added REGEDIT > HKEY_CURRENT_USER > SOFTWARE > Bigfix > BFEAdmin > Settings. Create the “AllowCustomUsername” in “Reg_DWORD” type with a value of 0x00000001 (1)
  (+ restarted)

Any other solution you guys have? We are still experiencing the same issue.

[GwyndafDavies]

Run the BESAdmin tool as different user (hold shift then right click on BESAdmin tool -> run as different user)
Then run as an user that has rights to the BFEnterprise database.
If needed, use SQL management studio to validate the user first, and check it has DBO righs over BFEnterprise and BESReporting.