Bill Wang’s Blog

December 18, 2008

Switch to use my old blog

Filed under: Uncategorized — Bill @ 11:18 am

Because blogs on wordpress.com are blocked in China. I decided to use my old blog: http://billwg.blogspot.com/. Sorry for the inconvenience.

December 2, 2008

Troubleshooting TF55030 error while running RenameDT

Filed under: Uncategorized — Tags: — Bill @ 8:04 am

While running RenameDT command, many customers getting error message TF55030: Rename Data Tier failed. Please verify that the supplied Data Tier name is a valid Team Foundation Data Tier name, that the Data Tier can be accessed on the network and that you have administrative rights. This error message is not precise enough to reveal what’s going wrong. So I’m writing this blog to help users diagnostic TF55030 error.

RenameDT comes from TfsAdminUtil family. Setting environment variable TfsDetailedErrors to 1 will make TfsAdminUtil to generate more detailed information.

We run RenameDT when the name of DT is changed or after TFS is moved. In TFS 2008, RenameDT command will perform the following tasks:

  1. Get the old DT name from TFS_Install_Folder\Web Services\Services\Web.config. The connection string to the DT is stored in this configuration file.
  2. Compute the connection string to the new DT by replacing the old DT name in the connection string with the new DT name passed to RenameDT command. This is why we need to set the connection string in Web.config to point to the old TD. The old DT will not be affected.
  3. Update the connection string for TfsReportDS and TfsOlapReportDS in the reporting service used by TFS to use the new DT name.
  4. Update the DT name stored in TFS databases.
  5. Update the connection string stored in the Web.config.
  6. Restart the IIS.

Now we know what’s going on when running RenameDT. When meeting TF55030 error again, please checking following things:

You have enough permission to run RenameDT command.

You must be a member of the Team Foundation Administrators group and a member of the sysadmin group on SQL Server. Please read “Required Permissions” section of the MSDN document RenameDT Command for more information.

You can connect to the new DT in AT machine.

You can open SQL Server Management Studio or create a .udl file on AT machine, verify you can connect to the new DT.

Reporting service works correctly.

You can use ConfigureConnections command to view and modify the reporting service URL used by TFS. After TFS is moved, you need to point the TFS to the new reporting service instance before run RenameDT.

 

One part of moving reporting service is restoring the old reporting service encryption key. Encryption key is used to encrypt sensitive data stored in reporting service database. The connection strings used by data source TfsReportDS and TfsOlapReportDS are encrypted too. Thus the old encryption key must be restored so that RenameDT can read and update the connecting string used by TfsReportDS and TfsOlapReportDS.

 

The easiest way to check if encryption is restored correctly is opening the reporting service in web browser. The default URL is http://TfsServer/Reports. If you get error message like “The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError)“, then it’s probably caused by that the correct encryption key used by the old reporting service instance is not restored.

 

If the old encryption key is lost and your reporting service is only used by TFS, you can simply delete the encryption key and reconfigure the connection strings for data source TfsReportDS and TfsOlapReportDS. If you can browse reports then the encryption key should be restored correctly.

After the above checks, please run RenameDT again. If your scenario is not included in the above checklists, please let me know.

Create a free website or blog at WordPress.com.