Crystal Reports - Report Failing over HTTPS

[dstolldorf]

We've recently added an SSL to our front facing client site. The rest of the site works and is able to make database calls through ASP.NET.

While accessing the site through HTTP the reports generate fine. If the protocol is changed to HTTPS, all reports are now returning the below image

The database connection is setup as an ODBC 32-bit connection so as I do not have to go through hundreds of reports to manually update the credentials (migrated from an older system). I've tried setting up the ODBC using the SQL Server Native Client 11.0 Version 2011.110.6540.00 and CR SQL Server Native Wire Protocol ODBC 7.1.5 Version 7.10.106.324. Either of these ODBC connections work within reports and while running the website locally in Visual Studio or in HTTP on IIS.

Crystal Reports 2016 Support Pack 5

Version 14.2.5.2618

Windows Server 2016 Standard

IIS 10.0

Microsoft SQL Server Standard (64 bit) Version 14.0.2047.8

As per this answer thread I've tried changing the application pool for the site to run in classic mode rather than integrated with no difference. The linked resource in the best answer returns a not found error.

Any help would be greatly appreciated!

[moshenaveh]

Welcome to the SAP Community! Thank you for visiting us to get answers to your questions.

I recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

[DellSC]

Which version of the Crystal .NET SDK are you using and which version of Visual Studio?

-Dell

[dstolldorf]

Visual Studio Professional 2017 Version 15.9.7

.NET Framework 4.6.1

All of the references within the project for CrystalDecisions has v2.0.50727

Referenced path: C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet\

Installed Apps

Crystal Reports runtime engine for .NET Framework (64-bit) Version: 13.0.25.3158

Crystal Reports, version for Microsoft Visual Studio Version: 13.0.25.3158

[moshenaveh]

dstolldorf

I'm glad to see you got an answer to your question! If it helps you, please make sure to accept (you'll see the "accept" option beneath the question) -- so members with similar issues will be able to find a solution to their problems too.

If it doesn't help, you can always leave a comment providing more details that can guide members who wish to assist you.

I hope that this guidance is useful -- and we look forward to your next question for the community!

[DonWilliams]

Hi Daniel,

Fiddle may show you it's trying to load a dll from the wrong place or could show a security issue.

CR runtime is platform specific so if your AppPool is 64 bit CR requires a 64 bit DSN, I don't see you mention that.

Set the Project to X64, not anyCPU, set up a 64 bit DSN

See if that helps.

CR does care if you use HTTP or HTTPS, security is all in the backend.

Don

[dstolldorf]

Hello Don,

Our server admin created a domain user and added that user to the server's IIS_IUSR group. We then changed the app pool to run using this new user. The rest of the website still works, ADO.Net commands are able to run and view compiling has access to the necessary temp folders. Still unable to generate reports with CR.

I then updated the project to run using the x64 platform. Given all the changes I had to make to the project to get that to build, I think it's safe to say it was building as a x86 app. I then made a 64-bit DSN and add web.config transformations so if deployed on the x64 platform it'll use the new DSN name. Deploying the app in strict 64-bit and strict 32-bit modes did not make any difference other than I saw w3p3.exe running under their respective deployed platforms. I also confirmed after deployment that the deployed web.config had the correct DSN.

I apologize, I am unfamiliar with the usage of Fiddler. What would I setup to get the web app to display access denied or incorrect dll loading in Fiddler?