1676954 - Error: "Failed to open the connection. Details: ADO Error Code: 0x80004005" while logging on to the SQL Server 2008 R2

SAP Knowledge Base Article - Public

1676954 - Error: "Failed to open the connection. Details: ADO Error Code: 0x80004005" while logging on to the SQL Server 2008 R2

Symptom

  • While logging on to SQL Server 2008 R2 using OLE DB (ADO) connection through Database Expert wizard of embedded designer of Visual Studio error is thrown.
  • Error: Failed to open the connection. Details: ADO Error Code: 0x80004005

error2.jpg 

Environment

  • Windows 7
  • Visual Studio 2010
  • Crystal reports for Visual Studio 2010
  • SQL Server 2008 R2

Reproducing the Issue

  1. Add a new report to Visual Studio application.
  2. In the Menu select Crystal Reports.
  3. Select Database >Database Expert.
  4. Create OLE DB (ADO) connection, select Microsoft OLE DB Provider fro SQL Server and following will appear:

vendot27.JPG

  1. Enter wrong Server name.

Cause

Server name was incorrect.

Resolution

  • As per the error description, SQL Server does not exist or access denied.
  • Ensure that desired server is selected.
  • Enter the correct information in the Connection Information window.

Keywords

failing not connecting db inbuilt cr4vs2010 crvs2010 cr4vs crvs database vendor code 17 80004005 , KBA , BI-DEV-NET , BI Software Development Kits (SDKs) - .NET or Other , Problem

Product

SAP Crystal Reports, developer version for Microsoft Visual Studio