SSRS Error: rsLogonFailed

Today I encountered an error when attempting to generate a newly deployed report in SQL Reporting Services. The error follows:

Logon failure. (rsLogonFailed)

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

The first area I examined was the data source and its stored credentials. That, of course, wasn't the issue as I was able to query data in Visual Studio as well as preview the report. When I realized that all other reports that had been previously deployed to the server generated the same error, I knew I had problem a with the server.

Fortunately a quick search online revealed the answer. The culprit was the server's Execution Account. This is defined in the Reporting Services Configuration tool as shown in the image below. You see, I used my domain account when performing this setup step when testing some other functionality months earlier - you are not required to specify an Execution Account by default. So when I changed my domain password several weeks ago this broke the generation of all reports on my report server.

Specifying the new password for my account resolved the issue and I was able to generate reports once again. Perhaps in the future I will use a domain account other than my own so that a change in password does not cause headaches.

Credit goes to user Nathan Griffiths-187644 of the sqlservercentral.com forums who posted the solution.