SAP Knowledge Base Article - Preview

3554471 - Error: Logon failed: 'IM006:[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed [Database Vendor Code: 18456 ] when attempting to connect to MS SQL Server from Crystal Reports

Symptom

  • Logon failed.
  • Fails to connect to MS SQL Server.
  • When attempting to connect to MS SQL Server from Crystal Reports via ODBC, it fails with the following errors:

    "Logon failed."

    Followed by the errors:

    "Database Connection Error: 28000:[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user '<USER NAME>'. [Database Vendor Code: 18456]"

    "Database Connector Error: 'IM006:[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed [Database Vendor Code: 18456 ]'
    01S00:[Microsoft][ODBC Driver 17 for SQL Server]Invalid connection string attribute [Database Vendor Code: 18456 ]


Read more...

Environment

  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
  • SAP Crystal Reports 2025
        
  • MS SQL Server 2016
  • MS SQL Server 2017
  • MS SQL Server 2019
  • MS SQL Server 2022

Product

SAP Crystal Reports 2016 ; SAP Crystal Reports 2020 ; SAP Crystal Reports 2025

Keywords

CR, logon failed , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.