[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 452
  • Last Modified:

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

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?
2 Solutions
Alpesh PatelAssistant ConsultantCommented:
You have to set the IP on IIS for SSRS 2005. and even set the permission for remote access of SSRS.
Nico BontenbalCommented:
jmarkfoleyAuthor Commented:
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now