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.