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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
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.

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
St3veMaxCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
carter-greenanAuthor Commented:
Thanks looks like that is the way I'll will have to go!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.