sql server report service 2005 displayed on intranet | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sql server report service 2005 displayed on intranet

I have a couple of questions to ask you about a sql server reporting service connecting to a webservice within the DMZ. I am asking this question since I want to avoid the double hop problems that occur by using IIS on sql server 2005. (This is when you use windows authenication in sql server 2005 to connect to IIS.)
The following questions pertain to using sql server 2005 and visual studio.net 2005:
1. If I want to have sql server report service 2005 connect to web service within the DMZ, is this possible? If so, are there URLS and/or books that I can look at that would be able to answer this question?
2. If question #1 is not possible, could I create a asp.net web page that would use some kind of a viewer contol that could display the sql server reporting service 2005 reports? This asp.net web page would then send the reports to a web service within the DMZ?
I want to use the web service so that the reports can be opened up on the internet.
Thanks in advance!

Have you found answers in the meantime?

Yes it is possible, see this MSDN http://msdn.microsoft.com/en-us/library/ms159272.aspx link and http://technet.microsoft.com/en-us/library/ms143736(SQL.90).aspx too for further action.

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |