SAP Knowledge Base Article - Public

1682092 - Error: Logon failed ADO Error Code: 0x80040e73 when connecting to SQL Server 2008 database

Symptom

Using "SQL Server Native Client 10.0" in the Crystal Reports XI R1 (11.0) Database Expert

At attempt to connect via OLE DB(ADO) results in the error:

Logon failed

ADO Error Code: 0x80040e73

Source: Microsoft OLE DB Service Components

Description: Format of the initialization string does not conform to the OLE DB specification.

Environment

  • MS SQL Server 2008
  • Crystal Reports XI R1 (11.0)

Cause

  • The name of the SQL Server client dll has been changed from SQLNCLI.dll  to SQLNCLI10.dll
  • Crystal Reports XI was designed to use SQLNCLI.dll
  • Crystal Reports XI does not support connection to  MS SQL Server 2008 via SQLNCLI10.dll

Resolution

Upgrade to Crystal Reports XI R2A (11.5)

See KB 1598392  - What is Crystal Reports XI R2A and where did all the CR XI R1 and  CR XI R2 updates go?

Keywords

Crystal Reports XI, MS SQL Server 2010, ADO Error Code , KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , Problem

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2