David Klein's Corner: SQL Reporting Services Error: Logon failed. (rsLogonFailed) Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)

Tuesday 12 August 2008

SQL Reporting Services Error: Logon failed. (rsLogonFailed) Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)

I've run into this SQL Reporting Services 2005 exception a couple of times now - typically when I have reporting services execution accounts run as domain users that have passwords which expire. You will get this error if the current credentials supplied for the report (or if none supplied, the current SQL Reporting Services Execution Account) are incorrect. This happened on my local machine and the simple fix was to update the password on my execution account.

Corrected the account username/pass... fixed!

8 comments:

Anonymous said...: Thanks, I had this exact problem :); 18 December 2008 at 08:50
Wilfredo Gameros Arones said...: thank you very much!!!!; 1 August 2009 at 00:20
Ketan Nawal said...: Thanks, it was helpful...

-ketan; 27 September 2009 at 07:46
Tej's said...: Thanks, It was helpful.; 20 April 2010 at 00:30
onur bıyık said...: This is very helpful. Thanks!; 20 July 2010 at 17:16
Unknown said...: Hello,

A simple question for you folks.

I have Domain group policy password set to expire.

Can anyone tell me what will happen when a user's password expire and he tries to access the SSRS Portal.; 20 March 2013 at 20:00
Unknown said...: Hello,

A simple question for you folks.

I have Domain group policy password set to expire.

Can anyone tell me what will happen when a user's password expire and he tries to access the SSRS Portal.; 20 March 2013 at 20:01
The Urban Monk said...: Worked for me!
Why is it these websites have better answers than Microsoft's own website!; 29 September 2015 at 10:00