Unable to access Report folder after installing SSL

Question

 

Hi VSTS team

 

Unable to access Report folder after configuring SSL

 

I have done Dual server installation in SQL server 2008 with TFS 2008.

 

After accessing the Team project, I see RED X mark on Reports and my sharepoint site is also not opening , however i am able to open working items and can also connect to source control.

 

Needed your help asap

 

Regards

Mohan

 

 

 

 

 

 

Answer 1

Hello Mohan,

 

   Could you please try the TfsConfigWss and TfsAdminUtil command again to refresh the connection links?

 

   More in:

 

        Walkthrough: Setting up Team Foundation Server to Require HTTPS and Secure Sockets Layer (SSL) 

 

        http://msdn.microsoft.com/en-us/library/aa833874.aspx

 

        ConfigureConnections Command TfsAdminUtil 

 

 

    And please also try to update the register value at the TFS Server.

 

  

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\9.0\TeamFoundation\ReportServer\80\Sites

 

    Please check the BaseReportsUrl and ReportsService keys to see if they point to the correct sites.

 

   Good luck.

 

Answer 2

 

Thanks for your response.

 

Tired TfsConfigWss and TfsAdminUtil command,  again  Issue ( RED X on reports ) is the same when i connect to Team project.

 

D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools>TfsAd

minUtil ConfigureConnections /ATUri:https://tfs01:443 /SharepointUri:ht

tps://tfs01:1443 /SharepointSitesUri:https://tfs01:1443/Sites

/SharepointAdminUri:https://fs01:2443 /ReportsUri:https://tfs

01:1443/Reports_TFS /ReportServerUri:https://fs01:1443/ReportServer_TF

S

TfsAdminUtil - Team Foundation Admin Utility

Copyright (c) Microsoft Corporation.  All rights reserved.

 

Fully qualifying URI parameter https://tfs01:2443 of switch SharepointA

dminUri by appending /_vti_adm/admin.asmx

Fully qualifying URI parameter https://tfs01:1443/ReportServer_TFS of s

witch ReportServerUri by appending /ReportService.asmx

Updating subscription number 1 from old address https://tfs01/WorkItemT

racking/v1.0/Integration.asmx to new address https://tfs01/WorkItemTrac

king/v1.0/Integration.asmx

Updating subscription number 2 from old address https://tfs01/WorkItemT

racking/V1.0/SyncEventsListener.asmx to new address https://tfs01/WorkI

temTracking/V1.0/SyncEventsListener.asmx

Updating subscription number 3 from old address https://tfs01/Warehouse

/v1.0/warehousecontroller.asmx to new address https://tfs01/Warehouse/v

1.0/warehousecontroller.asmx

Updating subscription number 4 from old address https://tfs01/VersionCo

ntrol/V1.0/Integration.asmx to new address https://tfs01/VersionControl

/V1.0/Integration.asmx

Successfully set application tier URI to specified value https://tfs01/

 

Successfully set SharePoint URI to specified value https://tfs01:1443/

Successfully set SharePoint Sites URI to specified value https://tfs01:

1443/Sites

Successfully set SharePoint Admin URI to specified value https://tfs01:

2443/_vti_adm/admin.asmx

Successfully set SQL Reports URI to specified value https://tfs01:1443/

Reports_TFS

Successfully set SQL ReportServer URI to specified value https://tfs01:

1443/ReportService.asmx

You have changed the Uniform Resource Identifier (URI) for a Windows SharePoint

Services site or SQL Server Reporting Services site. Team Foundation Server depe

nds on one or more of these sites. You must run the TfsConfigWss command-line ut

ility on the computer running Windows SharePoint Services before Team Foundation

 Server can function correctly.

 

D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools>

D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools>TfsCo

nfigWss ConfigureReporting /SharepointSitesUri:https://tfs01:1443/Sites

 /ReportsUri:https://tfs01:1443/Reports_TFS /ReportServerUri:https://tfs01:1443/ReportServer_TFS

 

D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools>

Got message " The reporting setting for the following wws sites were updated sucessfully 'https://tfs01:1443/sites"
 

 

 

 

Like to add some points

 

1. We are able to connent to the HTTPS reports link  from the Report server configuration manager

 

2. When I Rt click on the Team project > portal name it is directed to http link then i need to manual change to https to open portal 

 

needed your help ASAP

 

Answer 3

Hi,

Could you please try to delete the TFS registration cache on the Client? in order to do so you need to delete the cache folder.

The folder path is

%systemdrive%\Documents and Settings\%username%\Local Settings\Application Data\Microsoft\Team Foundation\2.0

on Win2k3 and Xp

and

%systemdrive%\Users\%username%\AppData\Local\Microsoft\Team Foundation\2.0 for Vista and Win2k8

 

Answer 4

Hi Abdou,

Thanks for your mail, we have done it issue still persists.

 

Addition info from the APP  tier log file

 

got 2 error msg:

 

 

1.

 

The description for Event ID ( 3355 ) in Source ( Windows SharePoint Services 3 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: servername\TFS, [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied..

 

2.

 

The description for Event ID ( 107 ) in Source ( Report Server Windows Service (TFS) ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Report Server Windows Service (TFS).

 

 

 

 

 

Will really appreciate for any other solution to resolve it

 

Regards

Mohan

Answer 5

I was able to cofigure the SSL settings for my TFS server except for the ReportServer.
You will notice that in the output of tfsadminutil the url generated does not match the one I sent in on the command line.

C:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools>TfsAdminUtil ConfigureConnections /ATUri:https://tfs.whact.com:8081 /SharepointUri:https://tfs.whact.com:443 /SharepointSitesUri:https://tfs.whact.com:443/sites /SharepointAdminUri:https://tfs.whact.com:30002 /ReportsUri:https://tfs.whact.com:443/Reports /ReportServerUri:https://tfs.whact.com:443/ReportServer
TfsAdminUtil - Team Foundation Admin Utility
Copyright (c) Microsoft Corporation.  All rights reserved.

Fully qualifying URI parameter https://tfs.whact.com:30002/ of switch SharepointAdminUri by appending /_vti_adm/admin.asmx
Fully qualifying URI parameter https://tfs.whact.com/ReportServer of switch ReportServerUri by appending /ReportService.asmx
Updating subscription number 1 from old address https://tfs.whact.com:8081/WorkItemTracking/v1.0/Integration.asmx to new address https://tfs.whact.com:8081/WorkItemTracking/v1.0/Integration.asmx
Updating subscription number 2 from old address https://tfs.whact.com:8081/WorkItemTracking/V1.0/SyncEventsListener.asmx to new address https://tfs.whact.com:8081/WorkItemTracking/V1.0/SyncEventsListener.asmx
Updating subscription number 3 from old address https://tfs.whact.com:8081/Warehouse/v1.0/warehousecontroller.asmx to new address https://tfs.whact.com:8081/Warehouse/v1.0/warehousecontroller.asmx
Updating subscription number 4 from old address https://tfs.whact.com:8081/VersionControl/V1.0/Integration.asmx to new address https://tfs.whact.com:8081/VersionControl/V1.0/Integration.asmx
Successfully set application tier URI to specified value https://tfs.whact.com:8081/
Successfully set SharePoint URI to specified value https://tfs.whact.com/
Successfully set SharePoint Sites URI to specified value https://tfs.whact.com/sites
Successfully set SharePoint Admin URI to specified value https://tfs.whact.com:30002/_vti_adm/admin.asmx
Successfully set SQL Reports URI to specified value https://tfs.whact.com/Reports
Successfully set SQL ReportServer URI to specified value https://tfs.whact.com/ReportService.asmx
You have changed the Uniform Resource Identifier (URI) for a Windows SharePoint Services site or SQL Server Reporting Services site. Team Foundation Server depends on one or more of these sites. You must run the TfsConfigWss command-line utility on the computer running Windows SharePoint Services before Team Foundation Server can function correctly.


is there somewhere that I can change this manually? based on my command line the value should be https://tfs.whact.com/ReportServer/ReportService.asmx


rich

PS - and the values in the registry are "https://tfs.whact.com/ReportServer" but the best practices analyzer is returning:

The Web service call "ReportingService.GetSystemProperties" at https://tfs.whact.com/ReportService.asmx failed. Check configuration at Microsoft SQL Server 2005 / Configuration Tools / Reporting Services Configuration. Error message: "There is an error in XML document (1, 2)."

Answer 6

Hi everyone

I think I have 3 issues:


Issue #1:
I am also trying TfsAdminUtil from cmd line and face same problem as Richard. May I know if there was a solution? Running this in cmd line does not result in the correct setting for me.

I have SSRS 2008, SQL 2008, TFS 2008 with SP1 (slipstream) on a Windows Server 2008 OS. I am also doing SSL and HTTPS on the TFS.

Issue #2:
I have checked this registry key too, but it is not set to the correct URLs. Is this not done with TfsAdminUtil?

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\9.0\TeamFoundation\ReportServer\80\Sites


Issue #3:
I have same error as Richard above too...  from Best Practices Analyzer report in for Cirtical Issues:

"ReportServer Web Service experienced call failure. There is an error in XML document (1,2)"  for ReportingService.GetSystemProperties.

After trying this guide, the url in BPA became worse. Now my webservice is reportservice20052005.asmx!
http://jritmeijer.spaces.live.com/blog/cns!8A48A27460FB898A!1091.entry


This is very confusing because all these settings not centralised. Any suggestion how to fix?

Answer 7

Hi all

I managed to get past this hurdle.

Basically TFS stores the same configuration key value in many different locations. Correcting one key doesn't guarantee the effect will be felt in all the different locations.

You should check all the following to ensure all parts are covered.

• Go to your Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools directory. From command line, run the following TFSReg /EXPORT TFSReg.txt YourAppTierServerName
  
  Confirm all keys are set appropriately for your Default Web Site, Sharepoint Central Admin and TFS services. The one that killed be was the following keys: Under <Type>Wss</Type> For BaseSiteUrl it should be http://yourapptierservername/Sites, but for BaseServerUrl it should be http://yourapptierservername/
• Go to your registry keys and check the following: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\9.0\TeamFoundation\REportServer\80\Sites. Make sure that BaseReportsUrl and ReportService is correct. ReportService should be the URL without asmx.
• Under your SQL database for TFS, go to the TfsIntegration database, the tbl_service_interface table. Ensure all the records here with http://something is set correctly.For ReportService record here, it must be http://yourapptierservername/ReportServer/ReportService.asmx, regardless if you are using SSRS2005 or SSRS2008. There is some strange workaround being done in the background of TFS that will modify the "ReportService.asmx" to "ReportService2005.asmx" if it is required.

Hopefully after checking all this, you will successfully be able to create your team projects. Good luck to all