Logon failure on SQL Reporting Server


  • When I want to view a report on SQL Reporting Server using FCS, the page finishs with the following error:


    Logon failed (rsLogonFailed)

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


    I installed FCS with administrator account, and I have been using it. But recently I can not view anything.




    Thank you.

    17 aprilie 2007 20:18

Toate mesajele

  • I am assuming that you have been able to access the reporting server before with the same username and password. But from the log, the username or password is incorrect. I would check that SQL, MOM and FCS are using the same database and are accessing with the same username and password
    18 aprilie 2007 15:15
  • SQL Reporting Services permissions are modified from the web interface http://server/reports and then the properties tab. From there you can allocate users/groups and their appropriate permissions
    18 aprilie 2007 20:53
  • I created two or three user accounts for using FCS. Each one is for SQL, MOM, and MOM DTS. In the installation (and the document) refers that. If I need to use one account for all services, please me notify me.

    However, the first days it works with out problems. Only the report area (14-day) is not working yet (since the installation).


    Thank you for your support.

    18 aprilie 2007 21:18
  • http://www.eggheadcafe.com/aspnet_answers/SQLServerreportingsvcs/May2006/post26747332.asp


    Removing the unattended execution account has fixed all of my reports. 


    I decided to follow that advice and bingo! it worked!

    21 iunie 2010 17:04