Skip to Content
author's profile photo Former Member
Former Member

Unable to connect to 2012 SQL database

I am trying to connect to a 2012 SQL database using the OLE DB provider panel for SQL Server. I have never used CR reports before, so this first go around hasn't been much fun. We are using CR version 14.1.1

When I try to connect, I get the following error:

Logon failed.

Details: ADO Error Code: 0x80040e4d

Source: Microsoft OLE DB Provider for SQL Server

Description: Login failed for user 'xxxxx\xxxxx'.

SQL State: 42000

Native Error: 18456 [Database Vendor Code: 18456]

The DBA folks don't know why this isn't connecting. When I suggested trying the ODBC interface, they told me that the Data Source Name should have had SQL in the list...and it doesn't. All that is in the source box is dBASE Files, Excel Files and MS Access Database.

Can someone help, please? We are trying CR as a trial to see if this will work for us. Obviously, if we can't get it to connect to the database, we won't be purchasing CR.

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Oct 09, 2014 at 08:41 PM

    Hi,

    Crystal is still 32 bit. If you have created an ODBC datasource and you cannot see that datasource in Crystal, that usually indicates the datasource was created using the 64 bit ODBC Administrator.

    If you have not created the ODBC datasource then you will need to do that using the 32 bit ODBC Administrator. Once you have created the datasource and tested it, Crystal should be able to connect to it when you create a new ODBC connection.

    Same goes for OLE DB.

    Good luck,

    Brian

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.