TfsAdminUtil and Reporting Services Service Account

The following is a snapshot of the error that you might see if the Reporting Services data sources are not updated when the account is changed or updated:

Reporting Services Error

---

• An error has occurred during report processing. (rsProcessingAborted) Get Online Help
  


• Cannot impersonate user for data source 'TfsOlapReportDS'. (rsErrorImpersonatingUser) Get Online Help
  


• Logon failed. (rsLogonFailed) Get Online Help
  


• For more information about this error navigate to the report server on the local server machine, or enable remote errors

---

SQL Server Reporting Services

If your Reporting Services service account has changed because you moved your Team Foundation Server installation or if you are using a different account, you will need to run TfsAdminUtil ChangeAccount.

In addition to this, you will also need to update the password and/or username for the TfsReportDS and the TfsOlapReportDS data sources manually using the Reporting Services web site at: http:///Reports/

More documentation on this topic: http://msdn2.microsoft.com/en-us/library/ms252480(VS.80).aspx

Changes to the VSTS for DB Professionals Download

Recently some changes to the download of the Visual Studio Team Edition for Database Professionals Add-on were made to try to clear up some initial confusion customers were reporting.

This is the add-on which installs into Visual Studio 2005 Team Suite edition and provides the additional functionality provided by Visual Studio Team Edition for Database Professionals.

Here is a quick list of the changes:

• Add-on no longer called a "Trial"
  The add-on can be used in a trial mode when installed with the Visual Studio 2005 Team Suite 180-day Trial Edition. When running in this mode you will get all of the Team Suite and Database Professionals functionality, and both of these solutions will stop working when your trial time period expires. However, if you own a "full" (non-trial) edition of Team Suite then this add-on will not expire since you are entitled to receive the Database Professionals functionality for free as a benefit of owning Team Suite edition. Hence it didn't really make sense to name this add-on a "Trial" by default when it can in fact be installed as a full add-on provided that you have an appropriate license to Team Suite.
  
• .EXE and .ISO available
  Previously only a .ISO file for download was offered, which required you to either mount that image or use a CD burning program to create media. They are still offering an .ISO file, but now they are also providing a self-extracting archive file (the .EXE) which you can download and quickly run to get started.
  
• Documentation Clarification
  Remember that this add-on does not provide the Team Edition for Database Professionals documentation. To get the documentation, you can either view it online or you can download and install a newer version of the MSDN Library which includes this documentation. The latest version is available here.

Hopefully those changes clear up some confusion - but if you still have questions please visit the Team Edition for Database Professionals Forum.

Working Offline with TFS

John Robbins has written a post called Working Offline with TFS. In it, he describes his approach to using Visual Studio when not connected to the Team Foundation Server. As many of you know, the server information is stored in the .sln file, and VS tries to connect to the server whenever you open a solution that contains the server information in its source control bindings. To make things go more quickly, he wrote a couple of custom MSBuild tasks to automate the process of adding and removing the bindings the solution files. While you don't have to remove the bindings while you're offline, it certainly makes opening the solution quicker when you know you can't get to the server.
For synchronizing with the server when he's connected again, he wrote an MSBuild task that wraps tfpt to use the online command. The online command will find and pend edits for any files in version control that are writable and don't already have a pending edit. Optionally, it will find additions and deletions (and there more options still -- run tfpt online /help for more information).
He pointed out a bug in tfpt.exe where you can't get the online command's dialog when standard out is redirected, which was also a bug in tf.exe. I fixed the bug in tfpt.exe to add the /prompt switch. Tf.exe also has the same issue, but we had already fixed the Orcas tf.exe a while back. So, the problem with not getting the online command's dialog as he describes will be fixed when the updated tfpt.exe is released, so long as you add /prompt (I don't know when, but it's not too far off in the future).

VSTS for DB Professionals Samples Project

A new project is now available on CodePlex for Visual Studio Team Edition for Database Professionals, please check it out http://www.codeplex.com/vsdbpro

The goal of this project is to share and collaborate on Visual Studio Team Edition for Database Professionals related sample projects and sample code.
In order to put some organizations in place they created five categories in which the samples have to fall.

• Data generators
• Data distributions
• Test conditions
• Sample projects
• Miscellaneous: tools and other helpful item that make the live of DataDude easier

IE Add-In for Submitting Web Bugs to TFS

Check this post (Automatically raise bugs from IE) on the Microsoft Developer Tools UK Sales Team blog for information about an Internet Explorer Add-In Neil Kidd developed for submitting Web Pages bugs with all the necessary accompanying information to TFS.
It can be downloaded from GotDotNet.

I've written an addin for IE to allow users to easily raise a complete bug
report. When the user indicates that there is a problem on the page, the
addin
will create a new Team System Work Item and populate it with the
following
information:

• A screenshot attached to the work item.
• HTML source of the page and any frames and IFrames attached to the work
  item.
• Any style sheets referenced by the page attached to the work item.
• Any script files referenced by the page attached to the work item.
• Details about the user's machine and browser (OS version, browser version,
  screen size, ...).

TFS Admin Tool 1.2 Released

Joe Morel just announced the latest release of TFS Administration Tool 1.2 on his blog, which can be found on CodePlex

This release adds the ability to administer TFS installations configured to use only SSL.