Moving Reporting Service in a TFS 2008 environment

On MSDN, we have documents for moving TFS database, moving Analysis Service database etc. But it’s not covered to move Reporting Service.

After I sent this question to our internal discussion group. I received a couple of replies. Especially thank Aaron Block, Bill Essary and Lakhminder Singh for their great help. Here are the steps to move RS.

  1. Follow KB 842425 to move RS DB to a new instance.
  2. Ensure that you have a login for the TFS Reports account, in case your RS databases are now going to be hosted on a different SQL instance. The login for the RS database should have RSExecRole in Report Server databases (which it should retain when you restore the RS databases.)
  3. Create new data connections for TfsReportsDS and TfsOlapReportsDS. They can be modified via http://ReportingService/Reports.
  4. Run TfsAdminUtil ConfigureConnections command to update setting /ReportsUri and /ReportServerUri.  Consider http://support.microsoft.com/kb/959126 while doing it.
  5. Copy TfsConfigWss.exe to the SharePoint server and run it there to update the reports redirector.
  6. In the installation folder of TFS, there’s a folder named “Microsoft Visual Studio 2008 Team Foundation Server - ENU”. Update the MSIProperty.ini in that folder and change the RS machine name for the VSTF_RS_SERVER property. You just need to give new machine\server name for RS & do not give the instance name. Optionally update the VSTF_RS_REPORTS_URI, & VSTF_RS_REPORTSERVER_URI properties. See Msiproperty.ini File Properties for more information.

8 comments:

guangming April 25, 2010 at 7:13 PM

Discount Handbags On Sale-Beautycasa Online : Official online destination for all things Louis Vuitton Handbags and purses including Luxury Handbags trends, designer reviews, handbag deals, and more.Hot sale Cheap cell phonesand cell phone china on our site! Fashion look and powerful functions for these mobile phones even discount cell phones! Wholesale HiPhone, 3G cell phones, PDA/Smart Phone now.China Cell PhonesDon't miss these cellphone!toy wholesale

wholesale electronics February 9, 2011 at 12:30 AM

Great blog and great post!!! 2945abc45 0209

Sony laptop keyboard July 14, 2011 at 4:31 AM

IT IS VERY USEFUL FOR THE BEGINNERS LIKE US. AND IT IS A GOOD OPORTUNITY TO LEARN SOMETHING FROM IT!

Web Application Development July 29, 2011 at 5:50 AM

Excellent post. I was checking continuously this blog and I’m impressed! It’s Very helpful information specifically the last part. I care for such info much. I was seeking this particular information for a very long time. Thank you and good luck.

Wind December 23, 2011 at 4:31 AM

Great tips.

commercial movers chicago August 28, 2012 at 11:31 PM

I love this superb blog post. Its share so interesting post with us. keep it up and update us daily with some unique articles.
commercial movers chicago

fdhty April 23, 2013 at 6:43 PM

Empty what's full. Scratch where it itches. Don't go around saying the world owes you a living rs gold, The world owes you nothing. It was here first. Being happy doesn't mean that everything is perfect Runescape Gold, It means that you've decided to look beyond the imperfections. Do not pray for tasks equal to your powersrs gold.

Many people in this life deny their freedom. They sit back in their misery and blame it on their parents, or their childhood, their health, or their financial problems Cheap Minecraft Gift Code, they never once stand up and take responsibility for their own lives and their own happiness Buy Xbox Live Points, of all the wonderful gifts that we've been given, one of the greatest is freedom Ultimate Game Card.

fnaf3 August 7, 2015 at 1:49 AM

You have a real ability for writing unique content.
----
five nights at freddy's | fnaf 3 | five nights at freddy's game