Crystal Reports 2013 SQL Server Connection Issues

[Former Member]

We have a Crystal Reports 2013 installation that does not want to connect to SQL Server. When connecting to a SQL Server DB we get the error message "Failed to open the connection." (see screenshot below).

There are no network connectivity issues with the DB, and we have tested the account, and other connection info in Management Studio with success. So I believe we are using the correct info for the connection string.

I have checked the CRConfig.xml file and if is configured properly, and all drivers are in the proper locations. As a side note, Oracle connections are working properly.

Any assistance, or suggestions would be appreciated.

Thanks.

[abhilash_kumar]

Hi Jeff,

Have you tried connecting to the db via OLEDB + the SQL Server Native Client 11.0 driver?

-Abhilash