http errors - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

http errors

Author

Topic

priyaram
Yak Posting Veteran

82 Posts

Posted - 2007-02-06 : 14:53:17

hi

i created endpoints and able to view wsdl

http://<servername>/hello_world
it's a stored procedure created in master database.
when i just try to view the output from this like

http:///<servername>/hello_world

it's giving me an error http501/http505 error.

i read in other article like, when soap is not able to process message , it'll be giving out as http errors.

my endpoint creation is as follows:

CREATE ENDPOINT hello_endpoint
STATE = STARTED
AS HTTP(
PATH = '/hello_world',
AUTHENTICATION = (INTEGRATED ),
PORTS = ( CLEAR ),
SITE = 'testserver'
)
FOR SOAP (
WEBMETHOD 'GetSqlInfo' (name='master.dbo.hello_world', SCHEMA=STANDARD ),
WSDL = DEFAULT,
BATCHES = ENABLED,
DATABASE = 'master',
NAMESPACE = 'http://testserver/hello_world'
);

GO

i already created a stored procedure hello world:

USE [master]
GO

CREATE PROCEDURE [dbo].[hello_world]
(@msg nvarchar(256)= "Hello Sql Server")
AS BEGIN
select @msg as 'message'
END

.I am not able to find any solution for this.Any help would be a great help for me.
i joined a new project , and this is the first task for me.

thanks for all

priyaram

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-02-06 : 19:08:32

What you are seeing is correct. HTTP endpoints are not accessible from a web browser (except for the WSDL). You have to use a SOAP client (a web service client) to access that URL.

priyaram
Yak Posting Veteran

82 Posts

Posted - 2007-02-07 : 08:43:45

Thanks for your reply.
And the webpage url i am able to access only from inside the server.Is it possible for me to access the url outside the server.???
For eg: from a internet explorer from my desktop.

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-02-12 : 17:04:25

You can access the endpoint from anywhere, but never with Internet Explorer or any web browser, you have to create a web service (SOAP) client.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources