Solved

SQL Reporting 2008 - Access from a TV

Posted on 2013-06-03
5
185 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
  • 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Sql server 2014 - Mobile apps 9 47
MS SSRS scale out 13 64
Data source in SSRS 2 42
SSRS Calculation of two fields not working 7 31
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

708 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now