SQL Server Performance Forum – Threads Archive
http error
hi i created endpoints and able to view wsdl http://<servername>/hello_worldit’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
Can you check the privileges and access rights to that SP for that user? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
i created on that sp and i am the admin for that server.i am running this using my windows authentication.
other than that , i don’t know what to check, shall you give me any command or some this , i’ll give you the results. really it will be a great help for me
]]>