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