TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
jasminie
NA
78
0
sql server connect to web service
Feb 7 2010 5:29 PM
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!
Reply
Answers (
0
)
get records between start day of a month and end day of the month
how to use cursor