trying to deploy a sproc as a web service from sql server 2005

[fguihen]

trying to deploy sproc as web service. Posted on: 03/06/2006 02:52:27




i have written a simple sproc and i want to expose it as a web service. heres the code i thought should do so:

Create ENDPOINT TestWebService5
STATE = STARTED
AS HTTP
(
PATH = /TestWebService5,
AUTHENTICATION = (integrated),
PORTS = (clear),
site = Dbrmsiis01
)
FOR SOAP
(
WEBMETHODTestWebService
(name=Rebate.dbo.TestWebService),
DATABASE = rebate,
WSDL = DEFAULT
)

now the server Dbrmsiis01 is a different, IIS server on the network. the server that sql server is on is different. everytime i try to view the WSDL, its not on the server. am i doing something wrong, or do i have the idea of whats going on wrong? what link do i type into the browser to see the page describing the web service, as in visual studio web services?

 

[PlausiblyDamp]

IIRC CREATE ENDPOINT creates the webservice directly within SQL server and has nothing at all to do with IIS.

It will not allow you to create an Endpoint on a remote machine either. Also it will only work on Win2k3 or WinXP SP2 or later.