Cant connect to Reporting Services from external IP

Hi,

I have a box that is hosting a web site and a reporting services instance that is holding reports used by the application. The app is using url access to access reports. If using the app by accessing it through http://localhost all works well, but connect from an external IP, even on the same box, it prompts for, and worse, does not accept username and password when trying to run the reports.

I have tested without using the app, and same thing happens. Connect to localhost/reportserver and it connects, but connect to externalip/reportserver and it prompts.

Please help, I have been struggling with this for days, and it is driving me crazy!!!
LVL 2
carter-greenanAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
St3veMaxCommented:
It's related to a couple of things.

Internally, You need to add the hostname: e.g. http://ReportServer.MyDomain.com to the 'Trusted Sites' in IE as in this zone, items will pass through authentication to the webserver when connecting.

Externally (Internet inbound) this is unavoidable as it's related to security.

HTH
0
 
carter-greenanAuthor Commented:
So are you saying that it's not possible to embed a report in a web app, without allowing all users to authenticate explicitly to your domain?

Can it not be tricked with certificates, IIS setup, or implemented through a web service or anything??? :-(
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
St3veMaxCommented:
It is possible, but depending on your data behind the scenes, the DPA may kick in.

If you were not fussed, you could set Reporting Services to allow Anon access, then set the credentials in your report data connection to a SQL Account.

HTH

0
 
carter-greenanAuthor Commented:
Ok cool, sorry to be a pleb, but I thought SSRS only used Windows Authentication. Where do I enable anonymous access?
0
 
St3veMaxCommented:
I believe you can add 'Everyone' in the home page of SSRS. I could be wrong...!!
0
 
carter-greenanAuthor Commented:
Oh, I have already done that. Also added the iis_isurs group, just in case. That was the first thing I tried. It is 2008 so it is through web service, so I can't do it in iis either...
0
 
carter-greenanAuthor Commented:
Thanks looks like that is the way I'll will have to go!
0
All Courses

From novice to tech pro — start learning today.