I deployed an upgrade to an end application. Ever since, some of the reports (Crystal Reports) do not work anymore on users’ systems. The platform version has remained stable.
During development and while testing no problems occurred. It turns out that having SQLServer Management Studio installed is required for a working report.
Without the management studio, Crystal Reports refuses to connect to the database.
I imagine that installing the management studio provides additional database drivers, without which the CR runtime is not able to connect to the database.
I have not been able to figure out which installable drivers the reports depend on, where to find such a driver, and why this is a problem all of a sudden.
One thing could be that development is done against a more recent SQLServer version, as we do not have access to post end-of-life databases for development. (The situation is not being helped by running a zombie platform version, because of difficulties procuring an upgrade for the database, and the bits of CR between bugs itself being outdated by half a century).
- There was a release of a new version of the end application
- CR reports stopped working on client machines that do not have SQL Management Studio installed
- To my knowledge, problems are encountered not only with edited reports
- development was done against SQLServer 2019
- production runs against SQLServer 2016
- TW platform is 2021.3; CR runtime release 25 with GUI 2022.x
- Things ‘used to just work’
Perhaps entering the right search phrase returns a direct hit either on the community or any search engine, but I have been unable to formulate the right set of keywords.