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)