how to access sql server reports from different host and/or explicit IP

Posted on 2012-09-19
Last Modified: 2012-10-10
I have configured SQL Server SSRS 2005 and created a report. It works just great if, on the hosting maching, I browser to http://localhost/Reports, or http://PowerSpec-PC/Reports (where PowerSpec-PC is the name of the machine), but does not work if I browse to, where that is the IP of the Reports-hosting machine.

Even worse, I can *only* access the SQL Server Reports from the machine on which SSRS is hosted. If I try any combination of URL from any other host on the LAN I get "Internet Explorer cannot display the webpage".

This latter objective is my chief goal. I want any user on the LAN to be able to access SSRS reports by typing some URL that finds its way to the SSRS hosting machine and retrieves the report.

How do I do this?
Question by:jmarkfoley
    LVL 21

    Accepted Solution

    You have to set the IP on IIS for SSRS 2005. and even set the permission for remote access of SSRS.
    LVL 22

    Assisted Solution

    by:Nico Bontenbal
    LVL 1

    Author Closing Comment

    This project has been put on ice for the time being, so I haven't pursued any of the solutions. Points for effort!

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Suggested Solutions

    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now