Solved

SQL Reporting 2008 - Access from a TV

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

770 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