I run TFS 2010 and SharePoint 2010 on my laptop so that I can demonstrate TFS without needing to be attached to a network (when on a customer site for example). My laptop is (rightly) subject to the corporate management policies so I need to change my password regularly and when I do so, because I use my account for a lot of the services, the integration between TFS and SharePoint needs updating.

Should you find yourself in the same, hopefully quite rare, position, then I’ve set out the steps you can take to fix this.

Symptoms

Once you update your password, then you will probably see the following error (Access was denied by the external data source) in the SharePoint dashboards:

TaskProgressAccessDenied

If you click OK then there is a report shown, but the dates will be wrong (showing 2010):

TaskProgressOldData

Resolution

The first step is to update the password in SharePoint Central Administration. In the main page, select Manage service applications

SharePointStep1

Then select the Secure Store Service (the application, not the proxy)

SharePointStep2

Now update the credentials for the TFS Target Application ID.

SharePointStep3

If you have more than one ID and you’re not sure which one to update then you can confirm the name in the TFS Administration Console. In the Extensions for SharePoint Products section, select Modify access and check the name of the Enterprise Application Definition:

EnterpriseApplicationDefinitionBlanked

Now update the credentials (same user name, new password):

SharePointStep4

The final step is to update the password used for Reporting Services in the TFS Administration Console:

ReportingUpdate2

This will then update all the Reporting Services data sources:

ReportingUpdateBlanked

Result

If you now open up the SharePoint Portal you should now not get an error and the data displayed will be up to date:

TaskProgressNewData

Cheers,
Giles