-
On the Team Foundation data-tier server, open SQL Server Management Studio. To open SQL Server Management Studio, click Start, click All Programs, click Microsoft SQL Server 2005, and then click SQL Server Management Studio.
-
On the Connect to Server dialog box, select Database Engine for the Server type. Select the appropriate server name and authentication scheme for the server. Provide a valid user name and password if you are required to by your SQL Server installation, and then click Connect.
-
In Object Explorer, expand Databases, expand TfsIntegration, and expand Tables.
-
In Tables, right-click tbl_service_interface, and then click Open Table.
The dbo.tbl_service_interface table opens for editing.
-
In the table, under name, find ReportsService. Edit the entry for url to match the new https value for Reporting Services. Make sure that you include the value that you specified for the SSL port for the Default Web site in IIS. For example, if you specified port 1443 for the Default Web site SSL port value in IIS, and your application-tier server was named Contoso1, you would modify the value as follows:
https://Contoso1:1443/ReportServer/ReportsService.asmx
-
In the table, under name, find BaseReportsUrl. Edit the entry for url to match the new https value for team reports. Make sure that you include the value that you specified for the SSL port for the Default Web site in IIS. For example, if you specified port 1443 for the Default Web site SSL port value in IIS, and your application-tier server was named Contoso1, you would modify the value as follows:
https://Contoso1:1443/Reports
-
In the table, under name, find WSSAdminService. Edit the entry for url to match the new https value for Windows SharePoint Services. Make sure that you include the value that you specified for the SSL port for the SharePoint Central Administration Web site in IIS. For example, if you specified port 2443 for the SharePoint Central Administration Web site SSL port value in IIS, and your application-tier server was named Contoso1, you would modify the value as follows:
https://Contoso1:2443/_vti_adm/admin.asmx
-
In the table, under name, find BaseServerUrl. Edit the entry for url to match the new https value for the default Web site for the Team Foundation application-tier server. Make sure that you include the value that you specified for the SSL port for the Default Web site in IIS. For example, if you specified port 1443 for the Default Web site SSL port value in IIS, and your application-tier server was named Contoso1, you would modify the value as follows:
https://Contoso1:1443
-
In the table, under name, find BaseSiteUrl. Edit the entry for url to match the new https value for the default Web site for the Team Foundation application-tier server. Make sure that you include the value that you specified for the SSL port for the Default Web site in IIS. For example, if you specified port 1443 for the Default Web site SSL port value in IIS, and your application-tier server was named Contoso1, you would modify the value as follows:
https://Contoso1:1443/sites
-
In the table, under name, find DataSourceServer. Edit the entry for url to match the new https value for the default Web site for the Team Foundation application-tier server. Make sure that you include the value that you specified for the SSL port for the Default Web site in IIS. For example, if you specified port 1443 for the Default Web site SSL port value in IIS, and your application-tier server was named Contoso1, you would modify the value as follows:
https://Contoso1:1443/ReportServer
-
In the table, under event type, find BuildCompletionEvent. Edit the entry for address to match the new https value for the Team Foundation Server Web site, including the value that you specified for the SSL port in IIS. For example, if you specified port 443 for the Team Foundation Server Web site SSL port value in IIS, and your application-tier server was named Contoso1, you would edit the value as follows:
https://Contoso1:443/WorkItemTracking/v1.0/Integration.asmx
-
In the table, under event type, find DataChangedEvent. Edit the entry for address to match the new https value for the Team Foundation Server Web site, including the value that you specified for the SSL port in IIS. For example, if you specified port 443 for the Team Foundation Server Web site SSL port value in IIS, and your application-tier server was named Contoso1, you would edit the value as follows:
https://Contoso1:443/WorkItemTracking/V1.0/SyncEventsListener.asmx
-
In the table, under event type, find ProjectCreatedEvent. Edit the entry for address to match the new https value for the Team Foundation Server Web site, including the value that you specified for the SSL port in IIS. For example, if you specified port 443 for the Team Foundation Server Web site SSL port value in IIS, and your application-tier server was named Contoso1, you would edit the value as follows:
https://Contoso1:443/Warehouse/v1.0/warehousecontroller.asmx
-
In the table, under event type, find the second instance of DataChangedEvent. Edit the entry for address to match the new https value for the Team Foundation Server Web site, including the value that you specified for the SSL port in IIS. For example, if you specified port 443 for the Team Foundation Server Web site SSL port value in IIS, and your application-tier server was named Contoso1, you would edit the value as follows:
https://Contoso1:443/VersionControl/v1.0/Integration.asmx
-
On the File menu click Save All.
-
Close SQL Server Manager.