How do I Setup & Configure SQL Reporting Services to work with SQL Server 2008
I am getting the following error on this during the final install of CRM. It seems to be from a setting I do not understand. What exactly is it saying I need to do? Please advise.
Setup failed to validate specified Reporting Services Report Server http://OURSERVER/ReportServer. Error: The operation you are attempting requires a secure connection (HTTPS).
System.Web.Services.Protoc
at Microsoft.ReportingService
at Microsoft.ReportingService
Setup failed to validate specified Reporting Services Report Server http://OURSERVER/ReportServer. Error: The operation you are attempting requires a secure connection (HTTPS).
System.Web.Services.Protoc
at Microsoft.ReportingService
at Microsoft.ReportingService
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Where do I do that. It sound like a more secure solution.....? Sorry I am a bit overwhelmed by all this.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The CRM installation does not seem to want to clear those Red X 's can I still go back an reconfigure or do I need to go in to the Report Services Configuration manager and go to the Web.
Where do I go to change that HTTP to HTTPS?
Is it a simple text entry change?
Where do I go to change that HTTP to HTTPS?
Is it a simple text entry change?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I heard that the HTTPS is more secure somewhere. Would it be smarter to go with the HTTPS? How
Yes when I click on the link I get the page that says Report Server no errors on that black and white page
See the image
webserviceURL.jpg
Yes when I click on the link I get the page that says Report Server no errors on that black and white page
See the image
webserviceURL.jpg
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Do I have to do the whole install again or can I just go back and see if the codes clear then move on.
You could just use the back button and try the new URLs.
ASKER
I did put in a unique port number which I have for CRM and....
In the install of CRM when Specifying the Report Services Server I saw the
http://OURSERVER/ReportServer
I was wondering if the Report Server URL was where I should put the change of the HTTP to the HTTPS
In the install of CRM when Specifying the Report Services Server I saw the
http://OURSERVER/ReportServer
I was wondering if the Report Server URL was where I should put the change of the HTTP to the HTTPS
Try that, change to HTTPS for your reprt server setting
ASKER
I think I am on to something thanks to you totally. When I went back and changed the pecifying the Report Services Server to HTTPS I got a much shorter message which makes me think now I need to do something..........that something I do not know to validate the certificate.
A server certificate could not be validated for URL: https://OURSERVER/ReportServer.
A server certificate could not be validated for URL: https://OURSERVER/ReportServer.
ASKER
Okay now both links are working they take me to a blank page with something like the image below.
When I try to back up say to the Specifying the Report Services Server then try to get past the " Systems Requirement" page I still get the red x with the error:
A server certificate could not be validated for URL: https://OURSERVER/ReportServer.
When I went back to do the bottom link the system asked me to accept a certificate. I did and when I went back to the link it launched me into the site I logged in and got the image below.
HTTPSLogintoServer.jpg
When I try to back up say to the Specifying the Report Services Server then try to get past the " Systems Requirement" page I still get the red x with the error:
A server certificate could not be validated for URL: https://OURSERVER/ReportServer.
When I went back to do the bottom link the system asked me to accept a certificate. I did and when I went back to the link it launched me into the site I logged in and got the image below.
HTTPSLogintoServer.jpg
ASKER
Some of these solutions helped us get a bit farther. We still do not have it completely configured. it was a help though. Thank you.
ASKER
MSCRM-SQLRPTSERVICESError.jpg