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
Environment
- Windows 7
- Visual Studio 2010
- Crystal reports for Visual Studio 2010
- SQL Server 2008 R2
Reproducing the Issue
- Add a new report to Visual Studio application.
- In the Menu select Crystal Reports.
- Select Database >Database Expert.
- Create OLE DB (ADO) connection, select Microsoft OLE DB Provider fro SQL Server and following will appear:
- 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