I've recently had to perform an update to my copy of the Microsoft-provided Team Foundation Server 2012 and Project Server 2013 virtual machine.
The virtual machine is running TFS 2012.1, SQL Server 2008 R2 Enterprise and Project Server 2013. Also, SQL Server Reporting Services was not needed for the demos performed on this VM, so it was never configured. Unfortunately, the upgrade can't complete successfully if SSRS isn't working. Given this configuration, there are a few prerequisites steps needed.
First off, login to the VM using the Administrator account (password: P2ssw0rd)
- This is as easy as running the Reporting Services Configuration Manager program and starting the service.
- Now go to the Web Service URL tab and click the Apply button to configure the web service.
- We need to do the same thing on the Report Manager URL page. Click the Apply button here too.
- We need to setup the database on the Database tab. Click the Change Database button. In the Report Server Database Configuration Wizard, select Create a new report server database then click Next.
- We are going to keep all of the defaults in this wizard, so just keep clicking Next, Next, Next. You will finally get configured, so click Finish to close the wizard.
- The Database tab should now show the configured database and credentials.
Update SQL Server
TFS 2013 does not support SQL Server 2008 R2 so we need to upgrade the database in-place. To do this, just grab your copy of SQL Server 2012 Enterprise with Service Pack 1 and run an Upgrade.
Note: Make sure you use the Enterprise version of SQL Server 2012 since the existing installation is Enterprise.
Upgrade TFS 2012.1 to TFS 2012.3
TFS 2012 Update 1 was a bit buggy, so I always recommend that folks go to the latest Quarterly Update before jumping major versions. This step will get the TFS databases upgrade and stable before we install TFS 2013.
As of this writing, TFS 2012 Update 3 is the latest releases version. Just grab the Update and run it on your server. Nothing special here.
Note: You are going to need the ISO (1.1gb) for this step and the next, so download that file instead of the Web installer (743kb).
Update the Project Server Extensions to TFS 2012.3
Install the Project Server Extensions for TFS 2012.3 from the ISO you downloaded for the last step.
Uninstall TFS 2012.3 Project Server Extensions
Yes, I know we just installed these, but that was to make sure the databases were all set. With that done, we need to get these bits off the server so we can put down the 2013 bits.
Go to Add/Remove Programs and uninstall the Project Server Extensions.
Uninstall TFS 2012.3
Again, we need to clear out the old bits to make room for the new bits. In Add/Remove Programs uninstall Microsoft Team Foundation Server 2012.
Install TFS 2013
Now we are ready to install TFS 2013. This is a simple install. When the installer is done, run the Upgrade Wizard to upgrade your databases. Remember, the password is always P2ssw0rd.
Install the Project Server Extensions for TFS 2013
Just like in the 2012 case, these bits are on the TFS 2013 ISO disk in the Project Server Extensions folder. Just run it and take the defaults.
You should now have a fully functional TFS 2013 with Project Server 2013 virtual machine to play with. Enjoy!