Partager via

Help! All of my reports fail with an authentication failure!

  • Article

Have your Reporting Services 2005 reports started failing recently with the error message?

Logon failed. (rsLogonFailed)

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

Check your Unattended Execution Account (UEA). Is it a domain user?

If so, check to see if the domain user's password has changed. Has someone intentionally changed that domain user’s password? Or, do you have a password expire policy in your network?

I run into this issue about once every so many days because our password policy enforces a password change every so many days and I use my account as the UAE. Once you update the password (via the Reporting Services Configuration Manager), the login failure should disappear.

Posted By : Evan Basalik

Comments

  • Anonymous
    February 13, 2007
    Thanks so much. This was my issue. Kenny

  • Anonymous
    April 09, 2007
    The comment has been removed

  • Anonymous
    June 10, 2007
    I am very glad I found this instruction. This is exactly the problem I had. I was going through all the permission settings and SQL accounts, to no avail. After I changed the UEA setting, everything is fine now. Thank you so much!

  • Anonymous
    July 22, 2007
    Thank you! That solved my problem (i mispelled the Account Name). After correcting it, everything is working fine.

  • Anonymous
    September 12, 2007
    I had the same issue. Have been burning myself the entire day. Thanks a ton!!!!!!!!!!!