Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Reporting Services Development  The report server cannot open a connection to the

Author  Topic  Medes_ Starting Member 1 Post Posted - 2007-03-29 : 02:48:24 Hi, I am newbie and working with an application that ueses report server 2000 to make reports. The problem is somebody has moved the database and changed some acounts and now I can not either get any report from the server or install my changes for reports. I used to run this commando to install changes for reports: rs -i PublishGeckoReports.rss -s http://IpAddress:32808/reportserver -v definitionPath="C:\Temp\Deployment\Reports\RDL" -v targetFolder="/MyReports" here is the error message i get when i try to install: System.Web.Services.Protocols.SoapException: The report server cannot open a connection to the report server database. The logon failed when I browse to http://IpAddress:32808/reportserver I get following: 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. at IIS Manager for default web site Enable Anonymous Access is checked and on the database server and the web.config file use same account and password. but I heard that somewhere there is encrypted password that i have to change it too. I need your help Thanks