Tuesday, July 21, 2020

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.

No comments:

Post a Comment