Another potentially easy one to fix. When you know how…………..

I received the error “Log on failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)” recently when trying to ‘run’ a report in Report Builder. From what I can gather, it has everything to do with the configuration settings for SQL Server Reporting Services.

Report Builder Logon Failure

Here are the steps to fix the issue:

• Open the Reporting Services Configuration utility (Start > Programs > Microsoft SQL Server 2005 > Configuration Tools > Reporting Services Configuration).
• Connect to the Report Server Instance that you are working with.
• Go to the Execution Account settings.
• Either uncheck ‘Specify an Execution Account’ OR Specify an account that is to be used (in my case I used a Windows account and password – as my set up uses Windows Authentication only)

Setting the Execution Account for Report Server

Try running the report in Report Builder again, it should work.