DAS & DTS Password Changed - Reporting Not Working
- 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 - The report server cannot open a connection to the report server database. The logon failed. (rsReportServerDatabaseLogonFailed) Get Online Help
所有回覆
- 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 - 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- 已提議為解答Salman Ali 2009年3月21日 下午 02:03
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
