Ask a questionAsk a question
 

Proposed AnswerDAS & DTS Password Changed - Reporting Not Working

  • Thursday, July 03, 2008 7:43 AMYasir Memon Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Hello Everyone Hope you all will be fit n fi9, i got an query for you Microsoft MVPs, hope i will get propper answer..

    i am new to SQL Database.

    i am using SQL Server 2005 with sp1 for reporting purpose, basically i have deployed forefront client security (Stand-alone single server deployment) in which SQL is deployed, while installing FCS i put the DTS & DAS Accounts as administrator account, after some time administrator password has changed so the reporting is not working anymore, i know i have to just update the password in SQL Accounts but i dont have idea how to do that, kindly help me out.

    below is the error message shown while accessing the reports:

     

    Reporting Services Error

    • The report server cannot open a connection to the report server database. The logon failed. (rsReportServerDatabaseLogonFailed) Get Online Help
      • Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)

    SQL Server Reporting Services



    waiting for your positive reply.

     

    BRegards


    M.Yasir Memon

All Replies

  • Monday, August 04, 2008 12:34 PMJohan Blom, Forefront MVPMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Yasir,

    You have to reenter the new password in FCS.

    On the FCS server, open the console and at the top you have a menu. click on Action -> configure.
    a config wizard starts click on next and enter the account and password when you are prompted.

    Good luck!

    /Johan
    MCSE, forefront spec | www.msforefront.com
  • Saturday, March 21, 2009 2:02 PMSalman Ali Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Proposed Answer
    You have to open the Forefront client security console go on action tab click on configure and reenter the details and new password and i will recommed you to make a sevice accounts DTA DSA use and add them on Local Admin group

    Thanks
    Salman Ali
    • Proposed As Answer bySalman Ali Saturday, March 21, 2009 2:03 PM
    •  
  • Sunday, October 11, 2009 7:54 AMsameh.khairy Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     

    You can refer to this link to update FCS service account password or change it if you need

    http://technet.microsoft.com/en-us/library/bb944783.aspx

    Thanks