Tuesday, July 21, 2020

SAP Crystal Reports trial key for older releases

While SAP doesn't come out and say it, it is possible to obtain a trial key for older releases where needed by registering an account with them in order to obtain a Crystal Reports 2016 keycode which will work with an older release such as what I deployed which was 2011 SP12 which was end of life, and end of support. This particular version was required to maintain compatibility with a software package that a client is using. In summary, as of the time of this writing, a new trial key will work with older versions, at least as far back as 2011 SP12.

SSRS native does not bind TCP ports configured

Should you be finding that an installation of Microsoft SQL Server Reporting Services (SSRS) is not binding to the configured TCP ports, the best place to look is in the log files. A default installation will be located at the following location: C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles. The log files in particular are named RSHostingService_* and you'll then likely be able to isolate the cause of the problem. In my case, it was a matter of installing SSRS after SQL Server that was purchased through volume license where product keys are not provided through the web site. The product key for SQL server purchased and downloaded via this manner is actually available on the ISO image in the root folder in a file named Default.ini. Use this product key to register SSRS. Note that if you've previously installed SSRS in trial mode, all of the enterprise features are enabled. If applying a server standard license, SSRS will complain loudly about various things, such as the Scale-Out not being supported which is what I was presented with. I hope that this helps someone else that forgot to license their SSRS installation and cannot figure out why it doesn't work after the evaluation period expires.