1915779 - Unable to create a report in Crystal Reports off a Universe based off an OLEDB connection to a MS SQL 2008 server

SAP Knowledge Base Article - Public

1915779 - Unable to create a report in Crystal Reports off a Universe based off an OLEDB connection to a MS SQL 2008 server

Symptom

  • Error: Logon failed.
  • Creating a report off a Universe in Crystal Reports fails with the logon failed error.
  • When attempting to create a report in Crystal Reports off a Universe based off an OLEDB connection to a MS SQL Server 2008 server, get the following error messages:

    " Logon failed.
      Details: ADO Error Code: 0x80004005
      Source: Microsoft OLE DB Provider for SQL Server
      Description : Invalid connection string attribute
      SQL State: 01S00 "

Environment

  • Crystal Reports 2008
  • SAP Crystal Reports 2011

Reproducing the Issue

  1. Create a Universe off a MS SQL Server 2008 database using an OLEDB connection.
  2. Install MS SQL Server 2005 OLEDB Provider on a local computer where Crystal Reports is installed.
  3. Install MS SQL Server 2008 OLEDB Provider on a local computer where Crystal Reports is installed.
  4. In Crystal Reports, attempt to create a report off the Universe based off the MS SQL Server 2008 database using an OLEDB provider.
    • 4.1  Under the menu "File", select "New - Blank Report"
    • 4.2  In the "Database Expert" window, double click on "Create New Connection"
    • 4.3  Double click on "Universes"
    • 4.4  Select the Universe and click "Open"
    • 4.5  In the “Business Objects Query Panel” window, add objects to the “Result Objects”, and click “OK”
    • 4.6  It will then display the following error message:

            "Logon failed.
             Details: ADO Error Code: 0x80004005
             Source: Microsoft OLE DB Provider for SQL Server
             Description : Invalid connection string attribute
             SQL State: 01S00 "

Cause

  • This issue arise if you have the MS SQL Server 2000, MS SQL Server 2005 and MS SQL Server 2008 OLE DB provider installed on the same computer.
  • Each OLE DB Provider uses a different driver, but Crystal Reports is not sent the appropriate provider information from the Webi Report Server, and therefore it fails to connect to SQL Server.
  • The issue has been identified and logged under the Problem Report ID: ADAPT01464121

Resolution

  • The issue is resolved in the following product updates:
       
    • Crystal Reports 2008:
      • Fix Pack 2.10
      • Fix Pack 3.4
      • Service Pack 4
             
    • Crystal Reports 2011:
      • Support Pack 04
          
  • Note: After applying the above product update, ensure you are using the apporpiate OLEDB provider for MS SQL Server:
    • Use the SQLNCLI OLEDB provider if you have either the OLEDB SQL Server 2000, or 2005, or if you have OLEDB SQL Server 2008 without the client installed.
    • Use the SQLNCLI10 OLEDB provider if you are using OLEDB SQL Server 2008 with the client installed.

Keywords

crystal report, universe, OLEDB, MS SQL 2008 Server, Logon failed,Error Code: 0x80004005 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011