features in .net 2005 verusus 2008

[jazzydance]

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.)

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.

The following questions pertain to using sql server 2008 and visual
studio.net 2008:
(I know that sql server 2008 does not use IIS. There is an http/system url
that is used instead.
1. If I want to have sql server report service 2008 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 2008 reports? This asp.net web page would then send the
reports to a web service within the DMZ?

Thanks in advance!

[PvdG42]

Post by jazzydance
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.)
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
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.
The following questions pertain to using sql server 2008 and visual
(I know that sql server 2008 does not use IIS. There is an http/system url
that is used instead.
1. If I want to have sql server report service 2008 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 2008 reports? This asp.net web page would then send the
reports to a web service within the DMZ?
Thanks in advance!

There appears to be a misconception in your problem statement that may be
causing you unnecessary concerns.

" (I know that sql server 2008 does not use IIS. There is an http/system url
that is used instead. "

Although there is a built in file based web server in VS 2008, there is no
restriction against working with IIS in VS 2008, if you wish. Perhaps that
removes some of your concerns.