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.
| Author |
Topic |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2010-02-07 : 22:06:26
|
| have a couple of questions to ask you about a sql server reporting service connecting to a webservice within the DMZ. 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? I want to use the web service so that the reports can be opened up on the internet. Thanks in advance! |
|
|
AdamWest
Constraint Violating Yak Guru
360 Posts |
Posted - 2010-02-08 : 17:28:28
|
| Number 2 for sure, I have done this. |
 |
|
|
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2010-02-09 : 11:58:43
|
| Can you give me more details on how to 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? I want to use the web service so that the reports can be opened up on the internet.Thanks! |
|
|
|
andrewhopkinson
Yak Posting Veteran
63 Posts |
Posted - 2010-02-23 : 15:29:34
|
| there is a webpage called reportviewer.aspx on the reporting server. It calls an object that generates the report. If you go to the Web Service URL under Reporting Services Manager and click on the report, you will see it. Open up the page it's calling and poke around, you can pass all kinds of parameters to it. |
|
|
|
|
|
|
sql report 2008 connections