Sign in
 
HomeProductsLibraryLearnDownloadsSupportForums
Microsoft Forefront TechCenter >
> 
> 
DAS & DTS Password Changed - Reporting Not Working

Locked DAS & DTS Password Changed - Reporting Not Working

  • Thursday, July 03, 2008 7:43 AM
     
     
    Sign In to Vote
    0
    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 PM
       
       Proposed
      Sign In to Vote
      1
      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
      • Proposed As Answer by Diego Castelli Wednesday, May 05, 2010 1:59 PM
      •  
         
      • Saturday, March 21, 2009 2:02 PM
         
         Proposed
        Sign In to Vote
        1
        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 by Salman Ali Saturday, March 21, 2009 2:03 PM
        •  
           
        • Sunday, October 11, 2009 7:54 AM
           
           Proposed
          Sign In to Vote
          1

          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  

          • Proposed As Answer by Diego Castelli Wednesday, May 05, 2010 2:00 PM
          •  
             
          • Wednesday, May 05, 2010 1:54 PM
             
             
            Sign In to Vote
            0

            Thanks Johan, Salman and Sameh: you actually solved my problem. I forgot there was a Wizard in forefront console... :-) although i'm the last one that should forget those info...

             

            Thanks.

            Bye!

            Diego Castelli
               
            • Wednesday, June 23, 2010 2:35 PM
               
               
              Sign In to Vote
              0

              Yasir,

              To make your life more easier, don't change the password for your service accounts. make it difficult to guess & share to few if you must. But if you have already, re-change it back and log in again. Good luck

              Nura