OK, I will try this today and get back to you shortly...

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html

OK, I got this to work. Here's how:

First, the stored proc:

CREATE PROCEDURE helloworld
(
      @msg varchar(256)
)
AS
BEGIN
      SELECT @msg
END

Now, test it.

exec helloworld 'helloworld'

Now, the endpoint:

CREATE ENDPOINT hello_endpoint
STATE = STARTED
AS HTTP
(
PATH = '/helloworld',
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR),
CLEAR_PORT = 8080,
SITE = '*'
)
FOR SOAP
(
WEBMETHOD 'GetSqlInfo'
      (
            name='Test.dbo.helloworld',
            FORMAT = ROWSETS_ONLY
      ),
      WSDL = DEFAULT,
      BATCHES = ENABLED,
      DATABASE = 'Test'
)
GO

Now, in your web browser, type the following URL:

http://localhost:8080/helloworld?wsdl

At this point, I got the wsdl page.

Try it and let me know what you get.



Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html

if i specify site ='*' it's not working.It's giving an error that the user doesn't have permission to register the endpoint .
Also i used

sp_reserve_http_namespace N'http://localhost:8080/hello_endpoint'

but still i got the same above error.
So i modified the site = 'localhost' then i typed the url http://localhost:8080/helloworld?wsdl. it's working fine with in the same server.

but i need to access from outside of server , i tried

http://<server_name>:8080/helloworld?wsdl

but it's giving an error

HTTP 400 - Bad Request
Internet Explorer

pleas help me out to make this url work outside of the server.

thanks,