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.

11 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

Anonymous November 5, 2017 at 10:33 PM

We provide registration services for arabic domain registration like .om, gov.om, edu.om, com.om & more. Register domain today!
Domain Pointing Services Oman

Anonymous September 12, 2019 at 8:52 PM

Amazing Post!! keep it up!! Thanks for share it with us!!web development company india

Situs Poker Idn Play October 30, 2019 at 10:38 PM

Artikel yang sangat bagus menarik dan bermanfaat

Bergabunglah dan rasakan sensasi bermain Situs Poker, Domino99, Pokerqq, QQ Online, Domino Qiu, Qiu Qiu Online, Poker Qiu Qiu yang memberikan kemenangan besar hanya di

http://Maxbetqq.net/ Agen Poker IDN terpercaya yang memberikan kemananga besar jackpot besar bersama Situs Poker Idn Play.

Dengan didukung server yang berkulitas dan permainan yang sangat fair 100% Player vs Player dan tidak ada campur tangan ROBOT di dalam Situs Poker Online Terpercaya

MaxbetQQ.

Promo HOT Di Poker Online Terpercaya Maxbetqq :
– Bonus Bulanan Megajackpot
– Bonus New Member 20% (Minimal Deposit Rp25.000 | Maksimal Bonus Rp.50.000)
– Bonus Rollingan 0,5%
– Bonus Deposit Rp. 5000 Setiap Hari
– Bonus Refferal 10% Up To 60%

7 Games Dalam 1 User ID :

✔️ Texas Poker
✔️ Domino QQ
✔️ Capsa Susun
✔️ Bandar Ceme
✔️ Ceme Keliling
✔️ Super Ten
✔️ Pot OMAHA

Info Maxbetqq Anda Bisa Langsung Menghubungi Lewat :

Livechat : http://Maxbetqq.net/
Whatsapp : +66613295868
WeChat : MaxbetQQ
Line : MaxbetQQ


QQ NET
QQ.NET
QQ PAGCOR
ONLINE QQ
DAFTAR QQ
QQ ONLEN
POKERQQ
POKERQQIDN
QQ ONLINE
DOMINO QIU
POKER ONLINE
MAXBETQQ.NET
SITUS POKER
AGEN POKERQQ
AGEN DOMINO99
POKER QIU QIU
QIU QIU ONLINE
Idn Poker
Idn Poker Apk
Agen Poker Idn
Idn Poker Play
Poker Idn Play
Situs Judi Poker
Idn Poker Terbaru
Game Poker Online
Situs Judi Poker Terbaik
Situs Poker Idn Play
Agen Poker Idn Terpercaya
Agen Poker Idn Terbaik
Situs Poker Idn Uang Asli
Bandar Poker Idn Indonesia
Situs Judi Poker Terpercaya
AGEN POKER UANG ASLI
AGEN POKER TERPERCAYA