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

(

WEBMETHOD'TestWebService'

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