After finally getting through the install of Reporting Services and Team Foundation Server and SharePoint I am getting an error when I try and create a Test project I'm getting an error. We have installed all of the components onto a Single Server Environment on a machine called VM-Foundation1. We have also installed an SSL certificate on the box for the URL AppDev.Company.com. All through the install we had to change various configuration files and a couple of registry entries to get all of the URLs and paths to the various parts pointing correctly and we also had to disable the Loop-Back check for Reporting Services because the certificate name is different then the name of the server. All of these changes we found on different posts mostly on this forum.

Each of the 3 sites on the box are setup to require SSL and all of the subsites and folders underneath each of these sites is setup to not require SSL as we have read. So what is happening is now that the install has completed we go into Team Explorer and attempt to create a new Team Project (we have done this on the server as an Admin to eliminate ny possible conflicts or confusions from that. When we do this it gets most of the way through the setup of the Project (about 80% or so) and then fails with the error that is attached below.

One other note we have uploaded a new Process Template without any issues so everything that is required for that is setup correctly. In the Team Project that we are attempting to setup here we are not using this custom template, so that is not where the problem lies. We are using the built-in Agile template when we setup this Team Project.

---begin Exception entry---
Time: 2006-08-30 17:13:12Z
Module: Engine
Event Description: TF30162: Task "Populate Reports" from Group "Reporting" failed
Exception Type: Microsoft.TeamFoundation.Client.PcwException
Exception Message: TF30225: Error uploading report : Work Item with Tasks
Exception Details: The Project Creation Wizard encountered a problem while
creating reports on the SQL Server Reporting Services on appdev.oceanspray.com.
The reason for the failure cannot be determined at this time.
Because the operation failed, the wizard was not able to finish
creating the SQL Server Reporting Services site.
Stack Trace:
at Microsoft.VisualStudio.TeamFoundation.RosettaReportUploader.UploadReport(ProjectCreationContext context, XmlNode report)
at Microsoft.VisualStudio.TeamFoundation.RosettaReportUploader.HandleCreateReports(ProjectCreationContext context, XmlNode node)
at Microsoft.VisualStudio.TeamFoundation.RosettaReportUploader.Execute(ProjectCreationContext context, XmlNode taskXml)
at Microsoft.VisualStudio.TeamFoundation.ProjectCreationEngine.TaskExecutor.PerformTask(IProjectComponentCreator componentCreator, ProjectCreationContext context, XmlNode taskXml)
at Microsoft.VisualStudio.TeamFoundation.ProjectCreationEngine.RunTask(Object taskObj)
-- Inner Exception --
Exception Type: System.Web.Services.Protocols.SoapException
Exception Message: The operation you are attempting requires a secure connection (HTTPS). ---> The operation you are attempting requires a secure connection (HTTPS).
SoapException Details: <detail><ErrorCode xmlns="http://www.microsoft.com/sql/reportingservices">rsSecureConnectionRequired</ErrorCode><HttpStatus xmlns="http://www.microsoft.com/sql/reportingservices">400</HttpStatus><Message xmlns="http://www.microsoft.com/sql/reportingservices">The operation you are attempting requires a secure connection (HTTPS).</Message><HelpLink xmlns="http://www.microsoft.com/sql/reportingservices">http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsSecureConnectionRequired&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=9.00.2047.00</HelpLink><ProductName xmlns="http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server Reporting Services</ProductName><ProductVersion xmlns="http://www.microsoft.com/sql/reportingservices">9.00.2047.00</ProductVersion><ProductLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId><OperatingSystem xmlns="http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem><CountryLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId><MoreInformation xmlns="http://www.microsoft.com/sql/reportingservices"><Source>ReportingServicesLibrary</Source><Message msrs:ErrorCode="rsSecureConnectionRequired" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsSecureConnectionRequired&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=9.00.2047.00" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">The operation you are attempting requires a secure connection (HTTPS).</Message></MoreInformation><Warnings xmlns="http://www.microsoft.com/sql/reportingservices" /></detail>
Stack Trace:
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.TeamFoundation.Proxy.Reporting.ReportingService.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties)
at Microsoft.VisualStudio.TeamFoundation.RosettaReportUploader.UploadReport(ProjectCreationContext context, XmlNode report)
-- end Inner Exception --
--- end Exception entry ---

Hi Paul,

There is currently another thread open with this same question. Check out the response that Othmane gives.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=687687&SiteID=1

-Matt

The problem here is that while your servers require SSL, the entries in the database for WSS and Reporting may not be pointing to the HTTPS location. You can check the entries in the database by hitting https://<server>:<port>/services/v1.0/registration.asmx. It will list out the interfaces in the database. You should be able to scan the list of interfaces (a long list) to see what is http vs https. If there are any issues, you may need to crack open the database and modify the interfaces in the tbl_service_interface table in the TFSService (I think that is the name) database. We do not recommend modifying the database, however this would be a necessary step to make it work.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.