WebApp wont connect to SSRS 2008
Hi everyone, Im struggling since a week with an SSRS installation at one of our customer. We have a Silverlight web app trying to connect to SSRS 2008 R2 running on a remote machine. Both machines are running Windows Server 2008 (Web App computer is running IIS7.0) and they are on a domain. Usually, we have to configure the web app's Web.config file correctly and it normally works but not this time. When it attemps to connect, it always returns "Unable to connect to the remote server. No connection could be made because the target machine actively refused it *IP of the SSRS machine*:8080". The weird thing is if i open IE on any of these two machine and type the URL, and enter asked credentials, it works fine! I suspect i have something wrongly configured in my config file, specially the appSettings and/or connectionStrings sections. Im using the same credential everytime (ive created an administrator-type user on the SSRS machine). Heres is the code (note that I have replaced confidential parameters with *Param*): <appSettings> <add key="net.virtualearth.common.staging.common" value="http://staging.common.virtualearth.net/find-30/common.asmx" /> <add key="ReportServerProcessingMode" value="Remote" /> <add key="ReportServerURL" value="http://*IP of the SSRS machine*:8080/Reports_MSSQL2008" /> <add key="ReportServerImpersonateDomain" value="*domain name*" /> <add key="ReportServerImpersonateUsername" value="*ImpersonateUserName*" /> <add key="ReportServerImpersonatePassword" value="*ImpersonatePassword*" /> </appSettings> <connectionStrings> <add name="TempConnectionString" connectionString="Data Source=*IP of the SSRS machine*;Initial Catalog=*CS DB Name*;User ID=*CSuser*;Password=*CSpassword*" providerName="System.Data.SqlClient" /> </connectionStrings> Any advice? Thanks
October 22nd, 2011 10:12am

Hi Maxti I dont have moch idea on Silverlight web app but below is the very good artical regarding Install and Configure Reporting Services on Windows Server 2008. http://technet.microsoft.com/en-us/library/bb839480(SQL.90).aspxSUHAS http://suhaskudekar.blogspot.com/ Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
Free Windows Admin Tool Kit Click here and download it now
October 22nd, 2011 10:25am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics