Skip to Content
Former Member
Jul 30, 2009 at 02:49 PM

"Logon failed" connecting to SQL Server database using OLE DB (CR 2008)


I am getting the following error when I try to connect to a SQL Server database using OLE DB from the Crystal Reports 2008 IDE.

I receive a similar error when trying to access the database by launching the report using the .NET CrystalReportViewer component.

My machine is running Windows XP SP3. I have already tried doing things like uninstall/reinstall Crystal, and have also used Microsoft's Component Checker to verify my MDAC 2.8 SP1 installation (I think this is the right component to check for OLE DB??).

Any help would be greatly appreciated!

Logon failed.

Details: ADO Error Code: 0x

Source: Provider

Description: Multiple-step OLE DB operation generated errors. Check

each OLE DB status value, if available. No work was done.

Native Error: [Database Vendor Code: -2147217887 ]