In this small post, I will show you how to reconfigure Team Foundation Server (TFS) using SQL Server 2008 R2. Here’s some background information:
I had installed TFS 2010 RC with basic settings which means that I had TFS 2010 RC installed on a box which was using SQL Express for storage. Because of this, there were no reporting as well as analysis services facility available. I wanted to change the SQL server Edition without reinstalling TFS. Here’s how I went about it:
- I installed SQL Server 2008 R2 with all the services.
- I started with removing the existing configuration on TFS by executing the tfsconfig tool. I used Program Files\Microsoft Team Foundation Server 2010\Tools path for using the tool
tfsconfig setup /uninstall:all
- Later I ran tfsmgmt configure. I used the advanced option of the wizard so as to select the SQL server instance name and report server.
That’s it. TFS was configured properly using SQL Server 2008 R2!