Skip to Content

Crystal Reports 13 drivers for SQL Server 18 database

This week my company began testing for upgrading all of their 2012 SQL Server Databases to SQL Server 2016. I had previously been using the Microsoft OLE DB Provider for SQL Server in my Crystal Reports 13 designer, and that connection no longer worked. I shifted to using the SQL Server Native Client 11.0 driver and that works on my local machine. These reports are deployed through Visual Studio .NET 2015 applications. When I attempted to run these from the test server, they failed with an error indicating they could not logon. I found documentation from Microsoft that where they had deprecated the Microsoft OLE DB Provider for SQL Server that they were restoring it and I found a place to download it, however, when I opened up Crystal Reports I saw no indication that it recognized the updated driver. When I attempted to run the report using the Microsoft OLE DB Provider for SQL Server the connection failed. Is there a driver available for Crystal Reports 13 that will allow me to connect to a SQL Server 2016 database under all circumstances?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jun 26, 2019 at 09:40 PM

    Hello Tony,

    Can you please check SAP note below

    2408765 - Failure to Open Crystal Report with Login Error When Using Microsoft SQL Server 2016 or 2017 for SAP Business One

    Thank you

    Yogesh

    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.