Crystal Reports v13 and SQL Server 2017

[former_member1250230]

We're currently migrating from SQL Server 2008 to SQL Server 2017. After we did this, our Crystal Reports now prompt for credentials when running and ultimately fail to connect, even after providing correct credentials. We have confirmed that all of the security permissions are correct on the SQL server. Is Crystal Reports v13 (i.e. 13.0.9) compatible with SQL Server 2017? Is there a driver that I need to install? Thanks in advance

[former_member1250230]

Thanks Dell, we'll give that a try.

[DellSC]

You'll need to do a couple of things:

1. Make sure that you're using SQL Server Native Client 11.0 instead of earlier versions of the ODBC driver to connect to SQL Server. This means that your ODBC connections will have to be recreated so that they use the new driver instead of the old one.

2. Upgrade your Crystal Reports 2013 to the latest service pack, which is SP12. You can download it from here for free: https://origin.softwaredownloads.sap.com/public/site/index.html

-Dell