Guillaume Rouchon

Translate original post with Google Translate

Je serai présent aux MSDays 2011 à Paris le 4 octobre en tant que Ask The Expert (ATE). Si vous avez des questions (notamment autour de Team Foundation Server et Visual Studio ) venez me voir !

Pour vous inscrire c’est ici : http://msdn.microsoft.com/fr-fr/microsoft-days.aspx

Carpe Diem.

Posts in this series:

1. Part 1: introduction
2. Part 2: the database server
3. Part 3: the Analysis Services server
4. Part 4: the Reporting Services server
5. Part 5 : the Sharepoint server
6. Part 6: the TeamFoundation Server server
7. Part 7: the TeamBuild server

In this third post we will see what to do to rename the reporting services server rs.demo.local to rs1.demo.local and make our services work again

Reporting Services

As for the Analysis Services server the only thing to do is rename the server and restart it. Now we’ll need to update dependant components:

• TFS
• Sharepoint

TeamFoundation Server

The only way to update TFS is by using the administration console:

1. Start the admin console.

2. Select the Reporting node and click the Edit button:

   
   Note: a popup will appear saying the jobs should be stopped before editing the values. Accept to stop the jobs..

3. In the dialog window select the Reports tab:
   • Update the Server field.
   • Click the Populate URLs button to automatically fill the Web Service and Report Manager fields.
   • Specify the Username and Password fields with the account information that will be used to read the cube data:
     
   • Click the OK button.
4. Click on Start Jobs to restart the jobs:
   

The Tfs_Configuration database is now updated. Let’s go and update Sharepoint.

Sharepoint

The dashboards in Sharepoint are displaying reports from Reporting Services. The reports’addresses are not hardcoded (thankfully ), the dashboards use a special page ”TfsRedirect.aspx” which will take data from the TFS server and redirect to the correct page. Those data are cached on the Sharepoint server, we must clear this cache so that the next call to TfsRedirect.aspx will get the new Reporting Services server name:

• Open a web browser.
• Go to “http://wss/sites/DefaultCollection/<TeamProject>/_layouts/TfsRedirect.aspx?tf:Type=ReportList&tf:ClearCache=1&tf:Test=1” (without the quotes) and replacing <TeamProject> with one of your team project name.

Here are some explanation on the url:

• The parameters starting with tf: are used by the TfsRedirect.aspx page. All other parameters are given to the redirected page. In our case there are no parameter to redirect.
• The tf:Type parameter indicates the redirection type. In our case we use the redirection to the report list page. We use this type because no specific parameters are required.
• The tf:ClearCache=1 parameter indicates to clear the TFS cache in Sharepoint.
• The tf:Test=1 parameter indicates the we only want to test the redirection and will display debugging data (settings, cached data, …) instead of redirecting to another page.

By using the Test parameter you can verify that the reporting server url is updated.

Your installion is back online using the new Reporting services server name. Next time will rename the Sharepoint server

Carpe Diem

Posts in this series:

1. Part 1: introduction
2. Part 2: the database server
3. Part 3: the Analysis Services server
4. Part 4: the Reporting Services server
5. Part 5 : the Sharepoint server
6. Part 6: the TeamFoundation Server server
7. Part 7: the TeamBuild server

In this second post we will see what to do to rename the analysis services server as.demo.local to as1.demo.local and make our services work again

Analysis Services

We start with the same step, rename the machine and restart it. And that’s all for this server

If you remember the infrastructure schema (if no, go read this series intro), two components use the Analysis Services server:

• TFS
• Reporting Services

We will start by updating TFS.

TeamFoundation Server

To update TFS we have two options:

• Use the TFS admin console.
• Use the TfsConfig command line.

We will see those two options and start with the admin console:

1. Start the TFS admin console.
2. Select the Reporting node and click on Edit:
   Note: a popup will appear saying the jobs should be stopped before editing the values. Accept to stop the jobs.
3. A dialog window will open, select the Analysis Services tab:
   • Update the Server field.
   • Specify the fields Username and Password with the account information that will be used to read the cube data:
   • Click on OK.
4. Click on Start Jobs to restart the jobs:

The Tfs_Configuration database is now updated. By using the console, the connection string for the data source Tfs2010OlapReportDS on the Reporting Services server is also updated, so no more work in this case

If you prefer using the command line, here what to do:

1. Open a command prompt.
2. Run the following command to remap the cube used by TFS:

   "%programfiles%\Microsoft Team Foundation Server 2010\Tools\tfsconfig" remapdbs /databasename:db1;Tfs_Configuration /sqlinstances:db1 /analysisinstance:as1 /analysisdatabasename:Tfs_Analysis

This will only update the Tfs_Configuration database, you’ll now need to manually update the Tfs2010OlapReportDS datasource connection string.

Reporting Services

If you haven’t used the TFS admin console, you need to update the Tfs2010OlapReportDS datasource:

1. Open a web browser.
2. Open the page http://rs/ReportServer
3. Click on the data source Tfs2010OlapReportDS :
   
4. Update the fields Connection String and Password (changing the connection string makes the password become invalid, just retype it):
   
5. Click on the Apply button at the bottom of the page.

Your installion is back online using the new Analysis services server name. Next time will rename the Reporting Services server

Carpe Diem.