SAP Knowledge Base Article - Public

2525758 - JDBC Trusted connection to SQL Server database using Crystal Reports

Symptom

  • Need to create a Trusted connection to SQL Server
  • Error: Crystal Reports is not configured for a Trusted Connection

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • MS SQL Server 2012

Reproducing the Issue

  1. Create a new JDBC connection for SQL Server database in Crystal Reports
  2. Enter URL, ClassPath and Check "Trusted Connection" box. See KBA 1527666
  3. Click Finish and get  "Crystal Reports is not configured for a Trusted Connection" error

Cause

Trusted connection requires 32 bit  sqljdbc_auth.dll  at specific location

Resolution

  1. Download the JDBC driver from Microsoft website
  2. Extract the driver package to hard drive
  3. Navigate to "x86" folder and copy the 32 bit version of sqljdbc_auth.dll 
  4. Place the sqljdbc_auth.dll to "C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\jre\bin" by default or whatever <JavaDir32> location configured in CRConfig file.  Default location for CRConfig.xml is  C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java
  5. Add the following entry to the <ClassPath> parameter in CRConfig.xml : C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\jre\bin\sqljdbc_auth.dll ;
  6. Save the changes and restart Crystal Reports

See Also

1527666 - How to set up a successful JDBC connection in Crystal Reports?

2066749 - How to create a Crystal Report using JDBC connection[Video]

 

Keywords

Integrated Security, Windows Authentication, WinAD , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016