Solved

SQL Reporting 2008 - Access from a TV

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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

Suggested Solutions

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

792 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