Solved

SQL Reporting 2008 - Access from a TV

Posted on 2013-06-03
5
192 Views
Last Modified: 2013-06-15
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
Comment
Question by:BruceLawrence
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 39216434
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
 

Author Comment

by:BruceLawrence
ID: 39216852
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
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 39216911
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
 

Accepted Solution

by:
BruceLawrence earned 0 total points
ID: 39234964
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
 

Author Closing Comment

by:BruceLawrence
ID: 39249739
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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

729 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