Post reply

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

  • June 26, 2009 at 4:37 am

    #1015895

    I had same problem .....if any one help me out .. it's appriciatable

  • July 2, 2009 at 7:48 am

    #1019156

    Thanks for your Tip.

  • August 30, 2009 at 7:42 pm

    #1046696

    Jacob Luebbers (4/15/2008)

    @rholt:

    It sounds like you may be running into a Kerberos delegation issue. Are your RS server and the source DB server running on different boxes? If so you may not have your RS server setup to correctly delegate the users' credentials to the DB server, so that final "2nd hop" connection is coming through as anonymous. This has been discussed a few times in various threads, the latest I recall was in a linked server context here. aureolin posted a link partway through the thread (http://msdn2.microsoft.com/en-us/library/aa905162(SQL.80).aspx) that gives you the details on correctly configuring your servers.

    Regards,

    Jacob

    Jacob,

    Thanks for the link, that solved my problem too. The SSRS service account had a valid SPN was not enabled for delegation itself.

    Regards,

    Nick

  • March 22, 2010 at 4:35 pm

    #1137911

    I just ran into this very same problem today on SQL server 2008 and the solution still works!

    Thank you for sharing it makes everyone's life a little easier!

    Ed Leffler

    http://www.lefflerlabs.com

  • July 15, 2010 at 12:21 pm

    #1193698

    Fantastic!

    This saved me lot of pain.

    Thanks

  • August 16, 2010 at 9:34 pm

    #1207643

    THAT WORKED!!! Marvellous!

  • September 13, 2010 at 6:55 am

    #1220003

    For Reporting Services try this.

    •Goto Reporting Services Configuration (in Start Menu->Programs->Sql Server->Config Tools.

    •Click on Execution Account

    •Uncheck "Specify an execution account"

  • October 21, 2010 at 1:06 pm

    #1240532

    Thank you!!!!!!

  • August 24, 2011 at 2:40 am

    #1372402

    It helped a lot for me... yehey!!!!!!!!:-D

  • February 15, 2013 at 1:17 pm

    #1588473

    Outstanding -- worked like a charm. Thank you very much!

  • February 21, 2013 at 8:32 am

    #1589995

    I did the same thing. The solution worked.

    Nathan Griffiths-187644 (9/17/2006)

    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! <img src='images/emotions/pinch.gif' height='20' width='20' border='0' title='Pinch' align='absmiddle'>

    cheers

  • September 29, 2015 at 1:19 am

    #1830053

    Hi All,

    Reporting Services stopped working after account password change ...which is used by SSRS Configuration manager.

    I have applied above solution but it doesn't work. I have also reset password of in windows service for SSRS logon account then restarted service .

    When I am trying to access ssrs web service url then it thowring below error.

    The report server cannot open a connection to the report server database. The log on failed. (rsInternalError) Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) .

    Where I have update new password for ssrs config account.

    Please suggest.

Viewing 12 posts - 31 through 41 (of 41 total)

You must be logged in to reply to this topic. Login to reply