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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 197
  • Last Modified:

SQL Reporting 2008 - Access from a TV

Good Morning

I have an interesting setup.  We recently purchased a few TV's that have WIFI and a built in browser.  We plan to display production reports on these.

I can browse the local IIS site no problem.  However, when I click on the link to the server hosting our reports, I get prompted for a username and password on the TV.  There is no way to authenticate with AD so I'm sure this needs configured to use anonymous?

How would I setup SRS 2008 to allow this TV to browse this report?  I've seen a few blogs about createing a new .dll file but I'm hoping for a more simple solution.
0
BruceLawrence
Asked:
BruceLawrence
  • 3
  • 2
1 Solution
 
Nico BontenbalCommented:
I suppose you are referring to this:
http://talksql.blogspot.nl/2011/12/setting-up-anonymous-access-for.html

But entering a username and password of a user that has access to the reports also works (at least for me when using a computer, not a tv, outside the domain).

Another option might be to have a script running somewhere that renders the report as an image, then show this image in the browser on the tv. See http://msdn.microsoft.com/en-us/library/ms153586.aspx
0
 
BruceLawrenceAuthor Commented:
Unfortunately I can't really compromise security with that solution.

I tried creating a local user on the server and using that but I'm still prompted for authentication.  I haven't looked into any scripts yet.

This is really disappointing.  I thought it would be a lot easier than this.
0
 
Nico BontenbalCommented:
When you log on to the server as that local user you created on the server, can you access the reports. Maybe something is wrong with the permissions on SSRS. Also when you use a user of which you are sure it has access to the reports on the TV does that work (just for testing, not as a final solution).
Never used a TV but I had something similar with an Ipad. It prompted for username and password, and when I supplied those it worked fine.

If you want to test the scription solution just open a report on the server and save it as an image (or as html). Then put that image somewhere on the server (in an IIS folder most likely) so it is accessible by the TV. If that works you can try to create a script that creates the file for you (and schedule it).
If you have SQL Server standard (and not Express) you can use a subscription to periodically save the report to a file.
0
 
BruceLawrenceAuthor Commented:
I've decided that the TV is too limited.  I was looking for an out of the box with little customization solution.

Decided to run the TV's off of an older laptop which renders the reports just fine.  Thanks for the suggestions.
0
 
BruceLawrenceAuthor Commented:
It was easier with less coding and customization.  I needed a quick solution and hooking up a laptop was much faster than hoping the TV would browse our Intranet.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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