Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

report server cannot open a connection to the report server database

Status
Not open for further replies.

bereza

Technical User
Jun 14, 2006
105
EU
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 -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 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
 
The people at the SQL Server forum will probably know more about your problem. (ANSI SQL is pretty much vendor independent.)
 
Better yet, the reporting services forum forum1462

:)

Alex

Ignorance of certain subjects is a great part of wisdom
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top