Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 sql report 2005

Author  Topic 

jassie
Constraint Violating Yak Guru

332 Posts

Posted - 2010-02-07 : 18:36:44
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.
Right now my company is using sql server 2005 and may upgrade to sql
server 2008 within the next couple of months.

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!
   

- Advertisement -