Skip to Content
avatar image
Former Member

ADO Error Code: 0x80004005 for SQL Server

Opening a report with vistual stuido and verify database (SQL Server 2012), it is fine.

But when verify database in the same report in SQL Server 2014, there comes a error:

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]

I saw the datasource provider is SQLOLEDB . When I change the datasource provider in report manually to SQLNCLI11, then the error was gone.

How to fix this issue without changing the provider manually?

Is there some mistake confirguation for SQL Server ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 15, 2017 at 05:45 PM

    Ask Microsoft to update their MDAC SQL Drivers to fully support SQL 2008 and above.

    Search MS site, they noted the MDAC drivers do not fully support new versions of SQL Server.

    No option in CR to make it work, that error is being generated by the SQL Server Clients.

    Don

    Add comment
    10|10000 characters needed characters exceeded