I did an upgrade today from TFS beta2 to RTM.  Everything worked fine except for the reports.

All the reports gave the following error:

“Logon failed. (rsLogonFailed) Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)”

After a few minutes, the error message has changed over to:

“Logon failed. (rsLogonFailed) The referenced account is currently locked out and may not be logged on to. (Exception from HRESULT: 0x80070775)”

The fix came from Grant Holliday via this link.  (Thanks, Grant!)

On the TFS application tier machine, run the Reporting Services Configuration editor.

Click the "Execution Account" tab.

Uncheck "Specify an execution account" and click Apply.

That fixes the problem.

-Ben

-- Need help setting up Team Foundation Server and/or Visual Studio Team System?  Need training on VSTS and TFS?  Want help configuring your source control, work items, and Team Builds?  Contact me via http://www.benday.com.