SQL Server Performance Forum – Threads Archive
not able to get output from endpoint
i already posted this question in developer forum, but i found this is the right place to post it.so i am doing it again. 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.
thanks for all priyaram
Can you refer that article that relates to WMI & SOAP issues, I guess this is related to database access issue. 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.
]]>