TB 18.11 – ODBC Error when Running Reports

/in /by

Topic: ODBC Error when Running Reports in DNA Fusion

Applies to: All versions of DNA Fusion

Summary: The following error message is displayed when running a report in DNA Fusion. Connection Failed, Cannot open user default, login Failed  This error is generated when SQL is set to the default NT Authentication setting.

Resolution: Add the DNAUsers group or individual windows credentials directly to the SQL Server Security Logins to allow remote connections. Newer versions of SQL server will not allow remote connections from the local users database security folder users.

Download Technical Bulletin (PDF): 

  TB 18-11 (303 KB)