Skip to Content
avatar image
Former Member

ADO Error Code: 0x80004005 for SQL Server

Trying to run a report using Crystal 2011 and getting a SAP Crystal Reports error when refreshing data and logging into the SQL database. Only happens on one workstation which is windows 7 (report runs fine on a XP workstation & the server) :

Logon failed.

Details: ADO Error Code: 0x80004005

Source: Microsoft OLE DB Provider for SQL Server

Description: [DBNETLIB}ConnectionOpen

(SECCreateCredentials0.]SSL Security error

SQL Stae: 08001

Native Error: 18 [Database Vendor Code: 18]

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Mar 02, 2012 at 03:17 PM

    See if the info in [this|ODBC Login Fails Everytime with CR 2011; forum thread helps.

    - Ludek

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 02, 2012 at 03:26 PM

    What version of MS SQL Server are you using?

    Don

    Add comment
    10|10000 characters needed characters exceeded

    • You can install the Native 10 driver on that one PC also and it should work fine.

      If you open the report up and click on Database, Set Location and expand the connection info you should see the SQL Native 10 driver listed. MS changed the dll name so CR needs to update the RPT files. If CR can't find the driver it could cause problems, better to make them all the same.

      Odd that it works but it could be those reports are not using any new functionality maybe....

      Thanks

      Don