Report Builder – Logon failure: unknown user name or bad password. (Exception from HRESULT: 0×8007052E)
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: 0×8007052E)” 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.
Thank you, tried a few solutions and yours was the the one that worked. Just spent 2 days trying to get report server working. First I couldn’t publish a model, eventually sorted, then it wouldn’t let me open report builder, eventually sorted and then I couldn’t run a report….Anyway, many thanks, you’ve saved me from having to quit my job!
Hi Brian,
So glad that it helped you solve your issue and saved you from a job search! I know I was puling my hair out when I went through this.
Thanks for the comment!
- Luke
Hi Luke.
I’ve got this issue, so I uncheked the “Specify an execution account” box but now I recive a different message “The data source type has not been specified”, but if continue using the box cheked with my user and password I get the bad password error. I have already verified the user and the password and put the same user… nothing happend.
If you have any idea it’d be appreciate.
Oscar.
Hi Oscar,
Did you manage to sort this out, or are you still struggling?