I am not sure if this is the right forum. Please let me know if it is not.
I am just wondering if I can create a http endpoint on a server that has
both SQL server 2005 and IIS 6 installed?
I am looking into ways to publish data in SQL 2005 to be used by an external
web application and thought that the native XML Web Services support will be
a great way to do it. But I don't want to mess around with it if it will
cause the IIS server to mis-behave...
Also, is that a wizard for doing native XML Web Services in SQL 2005? I
found the books online is not very clear on this topic (It tells you all the
commands, but did not mention the order one should execute them).
Any help will be appreciated.
Thanks.
Hello one,
> I am just wondering if I can create a http endpoint on a server that
> has both SQL server 2005 and IIS 6 installed?
Yes, but you'll have to configure one of the two to listen on a different
port. For example, you might want to leave IIS listening on port 80 while
you'd configure your SQL Services to run on 8080.
> I am looking into ways to publish data in SQL 2005 to be used by an
> external web application and thought that the native XML Web Services
> support will be a great way to do it. But I don't want to mess around
> with it if it will cause the IIS server to mis-behave...
Generally speaking it'll be fine. However, if your end consumer if a human
being and not an application, reporting services might be a better choice...
> Also, is that a wizard for doing native XML Web Services in SQL 2005?
> I found the books online is not very clear on this topic (It tells you
> all the commands, but did not mention the order one should execute
> them).
No, at least, not yet to my knowledge.
Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/
No comments:
Post a Comment