Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

RS SOLUTION - Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) Expand / Collapse
Author
Message
Posted Wednesday, September 6, 2006 7:47 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, September 23, 2009 7:09 AM
Points: 36, Visits: 8

I've been pulling my hair out with this problem.  I can create reports in BI Studio and see them return data. After I deploy them to the Report Server I get this error message when I try to execute the report:

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

I played with the data source and tried every conceivable credential option.  Here's the fix (which I picked up on another forum):

  • Goto Reporting Services Configuration (in Start Menu->Programs->Sql Server->Config Tools.
  • Click on Execution Account
  • Uncheck "Specify an execution account"

That's it. 

Post #306519
Posted Monday, September 11, 2006 8:00 AM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
Post #307621
Posted Sunday, September 17, 2006 11:50 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, October 19, 2008 9:26 PM
Points: 7, Visits: 17

I had the same issue on a dev machine - turned out I head used my own domain account as the Execution Account and when I changed my password it caused this error - and the moral of the story is never use your user account when installing software!

cheers

Post #309253
Posted Thursday, March 22, 2007 8:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 12, 2007 8:08 AM
Points: 2, Visits: 1
Thanks for the solution!
Post #353260
Posted Thursday, July 19, 2007 6:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 19, 2007 6:25 PM
Points: 1, Visits: 1

Jeff,

Thanks for this - I had just about run out of hair!

 

Post #383504
Posted Friday, October 12, 2007 12:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 7, 2014 5:25 PM
Points: 1, Visits: 220
This solution really works....
Post #409842
Posted Friday, December 21, 2007 12:04 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 14, 2008 10:51 AM
Points: 1, Visits: 4
Yes. this works, thank you.
Post #435819
Posted Friday, December 28, 2007 1:27 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 2, 2009 9:04 AM
Points: 1, Visits: 28
I tried this, but have not had any luck. I have reviewed my RS Logs and restarted the server/services several times over the past few days and de-selected the Execution account but still no luck. Just
"
Logon failed. (rsLogonFailed)
Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
"
If anybody has any otehr ideas, let me know.
Post #437206
Posted Thursday, February 7, 2008 8:12 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 1:22 PM
Points: 2,507, Visits: 1,139
:D
Thanks for your help!!
Post #452763
Posted Thursday, April 10, 2008 8:46 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 4, 2013 10:07 AM
Points: 1, Visits: 130
Awesome. Thanks for the tip. Saved me lots of frustration! :D
Post #483388
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse