IIS Default Web Site - Reports + ReportServer missing
-
Hi to all, its been a while
I am in the process of testing migration of our ERP system from Windows 2003/SQL 2005 Standard to Windows 2008R2/SQL 2012 Standard.
The SQL 2012 server is hosting multiple databases which in turn require sites in IIS (ports 80 / 443 / 8080/8443 are all used by other apps).
I have used 'Reporting Services Configuration Manager' as follows:
Web Service URL
TCP Port = 8081
SSL Port = 9443
Report Manager URL
Virtual Directory = Reports
URLS
http://ServerName:8081/reports
https://ServerName:9443/reports
If I browse to http://ServerName:8081/reports I receive error below.
"The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. "
I note in IIS (IIS Manager v6.1) that expected folders Reports and ReportServer do not exist. I thought these were created during installation?
Any tips/advice very much appreciated.
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
-
Hi. Has anyone else come across error "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel." when browsing the reporting manager URL?
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
-
Not sure what your error is but I would start with checking the SSL certificate that you are using .
Also, SSRS does not use IIS so you will not see anything to do with reporting services when you are using the IIS manager.
-
Thanks for the heads up on IIS, that explains that! As far as I am aware I am not using SSL or a certificate for SSRS? Reporting Services Configuration Manager > Web Service URL >
IP Address > All assigned
TCP Port > 80
SSL Certificate > (Not selected)
SSL Port > blank
Report Manager URL
If I click url http://ServerName/Reports I receive the error.
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
-
I am CONFUSED! I am unclear how Web Service URL and Report Manger URL interact and how SSRS uses certificates.
I managed to get past error "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel." by selecting a different TCP port (9443) and SSL Certificate within Web Service URL settings.
Even though I can now access SSRS 'Home' the icon from another hosted application is displayed before https://
Also https requested automatically redirect to https//
So http://server-name/Reports redirects to https://server-name/Reports. A certificate error is displayed even after installing the cert into Trusted Root Certification Authorities folder.
So to conclude:
I modified Web Service URL which removed/recreated bindings (a bit hit and miss, sometimes errors were generated regards not being able to create the binding)
Web Service URL now uses a different SSL certificate and SSL port (9443)
Report Manager URL uses the defaults (SSL cert and ports 80/443).
I can access SSRS 'Home' but only over https.
I still feel there is some sort of conflict with existing co-hosted applications + IIS web sites using the same certs/ports.
Kind Regards,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply