February 17, 2011 at 12:35 pm
I've been looking a long time for an answer to my problem, but have been unable to find one. This is my first post to this forum, so hopefully I'm describing this correctly:
I currently have a 2008 R2 report deployed on a box in domain A, and that report can be viewed by other users within that same domain (using IE 8). If I try to view this same report from another box on domain B, it does not find the report ("Internet Explorer cannot display the webpage") . There is no prompt for domain/user and password.
The IT folks here have separated our production environment from the nonproduction environment. There is no trust relationship established between domain A and domain B. Does anyone know how to get around this?
One note is that I have Sql Server 2005 reporting services set up on this same box in domain A, and it is possible to view a different 2005 report from the domain B after supplying the domain/user credentials. It's just not working for SQL Server 2008 R2...
Thank you for any advice,
Aaron Bentley
February 18, 2011 at 7:36 am
Unfortunately I don't have a great answer for you because security issues are a bit of a weak point for me. However, I know this is possible. At my last job we had some reports output to a public facing website for clients to use and it worked fine.
This is probably overkill but look into SSRS Security Extensions.
Good luck.
February 18, 2011 at 6:26 pm
Thanks for the tip, but I found out that all SQL traffic was blocked between the two domains. I'm guessing it worked with SQL Server 2005 reporting services because it used IIS, whereas SQL Server 2008 R2 does not. Publishing web pages with IIS was not an issue across the two domains.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply