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!
Will you give this article a +1 ? Thanks in advance