SQL Server Performance

not able to get output from endpoint

Discussion in 'SQL Server 2005 CLR' started by priyaram, Feb 7, 2007.

  1. priyaram New Member

    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
  2. satya Moderator

    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.

Share This Page