Tags

, , , ,

Hello Everyone,

Today I came across a strange issue with the Report Server. Actually due to some Issues I had to reinstall SQL in my DB server. During SQL Re-Installation I selected the Reporting Services to be configured automatically by default. After the Successful Installation of the SQL When I checked for the reports (http://localhost/reports),

It showed the ‘HTTP 500 Internal Server Error’ with the message ‘The website cannot display the page’ on the screen.

I was quite perplexed with this error as there was no warning/error-popup during the Installation. I then instantly checked with the ‘Reporting Services Configuration Manager’.

Under Report Manager URL section the URL field was blank !!! I tried multiple times to even set the Reports URL to port:80(which is set as default) but it failed with the Error: ‘The URL has already been reserved’.

With this error I got the hint that with my previous SQL installation, the port must have been reserved.

I Google it out to find a fix to this and from many suggestions I found this to be working fine, by using the Netsh command for Http. More description about the command is given here at msdn

Kindly follow the below steps:-

  • Firstly, Open the CMD prompt under ‘Run as Administrator’

 

  • Then type in the below command to check for the reservation:
netsh http show urlacl 

or

netsh http show urlacl http://+:80/Reports/

 

  • If you find the reservations for the same then in your next step you actually need to delete it in order to re-assign through the Reporting Services Configuration Manager.

To delete the reservation, kindly use the below command:

netsh http delete urlacl http://+:80/Reports/

 

Now after deleting the specified reservation when I configured back the URL under the ‘Report Manager URL’ section, this time it finally succeeded and my reports were opening in the browser.

Hope this will be helpful.

Thanks !!!
šŸ˜€