locked
WebApp wont connect to SSRS 2008 RRS feed

  • Question

  • 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

    Thursday, October 20, 2011 2:06 PM

Answers

  • Hi maxtin,

    Thanks for the question. Based on my research and past experiences, it seems like this issue caused by the IIS side.

    Which authentication type did you use for this webapp? If it is Anonymous Authentication, it will not pass the effective credential to the SSRS. In this condition, please try to change to Windows Authentication.

    Thanks,
    Sharp Wang


    Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
    • Proposed as answer by Sharp Wang Thursday, October 27, 2011 1:16 AM
    • Marked as answer by Sharp Wang Friday, October 28, 2011 1:09 AM
    Wednesday, October 26, 2011 8:10 AM

All replies

  • 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).aspx


    SUHAS http://suhaskudekar.blogspot.com/ Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
    Thursday, October 20, 2011 2:19 PM
  • Hi maxtin,

    Thanks for the question. Based on my research and past experiences, it seems like this issue caused by the IIS side.

    Which authentication type did you use for this webapp? If it is Anonymous Authentication, it will not pass the effective credential to the SSRS. In this condition, please try to change to Windows Authentication.

    Thanks,
    Sharp Wang


    Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
    • Proposed as answer by Sharp Wang Thursday, October 27, 2011 1:16 AM
    • Marked as answer by Sharp Wang Friday, October 28, 2011 1:09 AM
    Wednesday, October 26, 2011 8:10 AM