Solved

How do I Setup & Configure SQL Reporting Services to work with SQL Server 2008

Posted on 2010-11-18
16
1,531 Views
Last Modified: 2012-05-10
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.Protocols.SoapException: The operation you are attempting requires a secure connection (HTTPS). ---> Microsoft.ReportingServices.Diagnostics.Utilities.SecureConnectionRequiredException: The operation you are attempting requires a secure connection (HTTPS).
   at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetReportDefinition(String Report, Byte[]& Definition)
   at Microsoft.ReportingServices.WebServer.ReportingService2005.GetReportDefinition(String Report, Byte[]& Definition)
0
Comment
Question by:ruavol2
  • 9
  • 6
16 Comments
 
LVL 7

Accepted Solution

by:
rashmi_vaghela earned 100 total points
ID: 34170357
0
 

Author Comment

by:ruavol2
ID: 34172028
Here is the Actual Screen Shot of the error. Am I doing the right thing with the configuration of the SQL Reporting Services.


MSCRM-SQLRPTSERVICESError.jpg
0
 
LVL 5

Assisted Solution

by:HighlanderX
HighlanderX earned 400 total points
ID: 34174447
Have you tried addressing the report server as HTTPS:// ?
0
 

Author Comment

by:ruavol2
ID: 34174483
Where do I do that. It sound like a more secure solution.....? Sorry I am a bit overwhelmed by all this.
0
 
LVL 5

Assisted Solution

by:HighlanderX
HighlanderX earned 400 total points
ID: 34174527
When the CRM installation asks for the Report Server location, try using https://OURSERVER/ReportServer
The error you are getting is implying you are trying to connect through the normal port but it is expecting connection through SSL.
0
 

Author Comment

by:ruavol2
ID: 34174879
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?
0
 
LVL 5

Assisted Solution

by:HighlanderX
HighlanderX earned 400 total points
ID: 34174918
You may be better off pressing cancel and running the CRM installation again (if this is not what you already did).

Before you do start the installation again, go into the Report Services configuration and see what the URL is for reporting services, usualy you will have http://OURSERVER/ReportServer and http://OURSERVER/Report.  Ensure you are able to go to those URL's in your web browser, even if you are then faced with an empty FTP style folder list, you will have access.  Then ensure this is the address you use in the installation of CRM (this is one of the last screens before you get the above messages).
0
 

Author Comment

by:ruavol2
ID: 34175013
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
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 5

Assisted Solution

by:HighlanderX
HighlanderX earned 400 total points
ID: 34175077
It would appear you are using SSL and the links are connecting fine.
Try going through the CRM installation again, but copy and paste the URL of the reporting server from your browser.
It looks like it is allowing traffic on both port 80 and 443 (SSL) so try the second link first (https) - if that fails press the back button and try the first link (http).
0
 

Author Comment

by:ruavol2
ID: 34175148
Do I have to do the whole install again or can I just go back and see if the codes clear then move on.
0
 
LVL 5

Expert Comment

by:HighlanderX
ID: 34175171
You could just use the back button and try the new URLs.
0
 

Author Comment

by:ruavol2
ID: 34175185
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
0
 
LVL 5

Expert Comment

by:HighlanderX
ID: 34175220
Try that, change to HTTPS for your reprt server setting
0
 

Author Comment

by:ruavol2
ID: 34175247
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.
0
 

Author Comment

by:ruavol2
ID: 34175658
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
0
 

Author Closing Comment

by:ruavol2
ID: 34219549
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.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Testing connection to sql 7 58
Upgrading SQL 2005 Express to 2008 R2 Express 31 68
Need help with a query 6 67
Value Lookup 10 41
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now