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

• 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 "

• Crystal Reports 2008
• SAP Crystal Reports 2011

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 "

• 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

• 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.

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