Tuesday, March 20, 2012

Report Builder logon failed

I used an sql server logon to create the view and model in designer, I deployed the source and model from desigen, when I go to report builder I get this message:
  • Logon failed.
  • Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) My server and web service are on the same server and I set up my server security to use mixed mode if that makes a difference.to answer my own question, even though it said it set up the rs service account correctly, it set up a new one with appropriate security and it now works, I just deleted the old id and use the new one.|||

    hi there!

    i encounter the same error... how did u find the id? i am using the domain account.. how can i make the necessary changes?

    if i have to run my report in the client workstation, i got this error msg:

  • Logon failed.
  • For more information about this error navigate to the report server on the local server machine, or enable remote errors|||

    I'm encountering the same error and cannot seem to get the issue resolved. I setup a new report server on my local machine and deployed a model to it and it works fine.

    However, on my 2003 server I get the message

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

    Can you please explain how exactly to rectify this error?

    Thanks

    |||

    Go to management studio, create a LOGIN give it access to the msdb, reportsever database and reportserver temp database. See

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_75k2.asp

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

    Post a Comment