TF255050 TFS and Reports setup

Recently, whilst helping a customer upgrade to TFS 2013 we hit an issue configuring SQL Server Reports within the TFS Admin console.

 

In this particular dual tier configuration, SQL Reports was setup on a different server to the TFS databases.  Here the solution was to ensure that the account that TFS was running under was a local admin on the SSRS machine whilst TFS Reports was configured.  This can be removed once it's be setup.