I am trying to get Reporting Services working for a web app that collects object data via SQL. We have a production server that is running 2008 R2 and many reports that we need for beta deployment were already written using the Reporting Services feature on that instance. Hence, I was really excited to find that SSRS was included with 2012 Express.
However, despite the fact that I have set up Reporting Services via the Configuration Manager, I cannot seem to get it to respond to requests from even a single website on my test instance. In other words, I can connect to ReportManager and ReportServer (that is how I've configured the "URLs" [directories] in the Config Manager), but I can't connect to them from a DNS such as test.website/ReportServer or test.website/ReportManager for websites hosted via IIS 8.
Here's my configuration:
website/ == IIS managed, open on port 80 and port 443; displays a single HTML page
test1.website/ == open on port 443 only; running ASP.NET/MVC/TSQL web app
test1.website/ == dummy website open on port 80, redirects all requests to relative port 443 directories
test2.website/ == open on port 443 only; running ASP.NET/MVC/TSQL web app
test2.website == dummy website, redirects all traffic to relative port 443 dirs
Reporting Services configured as indicated above, with the following bindings:
ReportServer == open on port 80 (.+)
I haven't connected it to port 443 because it doesn't see the self signed certificate (like I said, this is a test). But it won't even connect from the root domain (i.e., website/ReportServer). It won't authenticate. I tried setting up an Execution Account and that doesn't work either.
Please tell me if I'm doing something wrong or if there are additional steps I can take to get it to work. Ideally I would like multiple reporting servers for multiple instances of the web app in a cloud setting, but I can't even get one to work in a test environment! Also, I can't seem to find the reporting services configuration file (rsreportserver.config), so any pointers there would be appreciated.
Thank you so much,
Chaim Eliyah Machete Project