Rendering an ASP.NET page using CrystalReportViewer component does not work with Windows Server 2022 Datacenter Azure Edition, using Microsoft SQL 15.0.4198.2. I have the Crystal Reports Runtime engine for .NET Framework (64-bit) installed on the server. The page sets database credentials for the report but now when the report is run in this page in the browser, the user is re-prompted for credentials. Even when correct credentials are entered, the following error is returned: Database Logon prompting is in invalid state.
Based on a similar question from 2020, but this is for a new version of Windows and the old answer did not work. I am using Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) for my database connection.