Error using the Web Reports

Usage and Config Platform
1

(imported topic written by slybel)

Good afternoon.

We recently are getting this error using the Web Reporting tool:

Cannot connect to the Web Reports database: ODBC Exception:

Microsoft

ODBC SQL Server Driver

SQL Server

Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection… Refresh the page to try reconnecting. If the problem persists, contact a database admin or BigFix technical support

I have tried to reboot the server, restart the web services and fidled around with the SQL with no success.

Please help.

thank you.

2

(imported comment written by BenKus)

Hi slybel,

This error usually means that you are trying to use usernames/passwords to log in when using an NT authenticated connection.

Double-check the following:

  • Your SQL Server is set to use NT Authentication and Windows Authentication.
  • In the “Database” settings in the web reports, make sure you are using the appropriate system DSN (“bes_bfenterprise” by default) and authentication type (“Windows Authentication” by default).
  • Make sure that the DSN you are using matches the authentication of the ODBC settings (you can look at the DSN ODBC settings in your Windows Administrative Tools folder).

Hope that helps,

Ben