How to use SSRS in SOA application RRS feed

  • Question

  • Hi,

    We have web application implemented using service oriented architecture (SOA) which is Web server, App server and DB.

    Web server has aspx pages and app server has web services (asmx) and DB is database server.

    Data will be retrieved from database to web pages through web services as web server can't communicate to database server directly.

    Now we have to use SSRS for the reports. Can some one suggest which is the best approach whether to configure SSRS in app server (where web service installed) or in database server. If we configure SSRS in database server can we able to access the SSRS report service URL from web server as DB port is not opened in web server.

    Please advice.

    • Edited by Monday, August 24, 2015 3:18 AM
    Monday, August 24, 2015 3:17 AM


  • Hi,

    There is a forum specified for SSRS issue, I suggest you ask this to SQL Server Reporting Services, Power View forum.

    Best regards,


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Tuesday, August 25, 2015 9:14 AM