[dba-SQLServer] ) errors

http://codebetter.com/raymondlewallen/2005/06/24/create-a-web-service-directly-from-sql-server-2005-using-an-http-endpoint/

looks very similar to your code. Perhaps it is what you started with?

perhaps you are still missing something prior to that statement?

GK

On Fri, May 25, 2012 at 2:28 PM, Jean-Paul N <jnatola at hotmail.com> wrote:
>
>
> Everything I can find indicates that creating an http endpoint is suppored in sql 2005
> yet I still get "This "CREATE ENDPOINT" statement is not supported on this edition of SQL Server."
>

>
> Jean-Paul Natola
>

> ----------------------------------------
>> From: jnatola at hotmail.com
>> To: dba-sqlserver at databaseadvisors.com
>> Date: Thu, 24 May 2012 15:47:54 -0400
>> Subject: Re: [dba-SQLServer] ) errors
>>
>>
>> I think you are onto something , removing the comma now returns this error Msg 7878, Level 16, State 1, Line 1
>> This "CREATE ENDPOINT" statement is not supported on this edition of SQL Server.

>> Jean-Paul Natola
>>
>>
>>
>> > Date: Thu, 24 May 2012 14:43:14 -0500
>> > From: garykjos at gmail.com
>> > To: dba-sqlserver at databaseadvisors.com
>> > Subject: Re: [dba-SQLServer] ) errors
>> >
>> > Comma at end of line 11?
>> >
>> > On Thu, May 24, 2012 at 2:22 PM, Jean-Paul N <jnatola at hotmail.com> wrote:
>> > >
>> > >
>> > > hi all,
>> > >
>> > > I'm trying to figure out what sql doesnt like about this parenthesis; LINE 12
>> > >
>> > > CREATE ENDPOINT WebServiceTest
>> > > AUTHORIZATION [sa]
>> > > STATE = STARTED
>> > > AS HTTP
>> > > (
>> > > AUTHENTICATION = (INTEGRATED),
>> > > PATH = '/MyTestWebservicepath/',
>> > > PORTS = (CLEAR),
>> > > CLEAR_PORT = 8045,
>> > > SITE = '*',
>> > >
>> > > ) THIS PAREN THROWS THE ERROR
>> > > FOR SOAP
>> > > (
>> > > WEBMETHOD 'urn:www.codeproject.com'.'GetProduct'
>> > > (
>> > > NAME = 'Northwind.dbo.GetProduct',
>> > > SCHEMA = STANDARD,
>> > > FORMAT = ALL_RESULTS
>> > > ),
>> > > WSDL = DEFAULT,
>> > > BATCHES = DISABLED,
>> > > SCHEMA = STANDARD,
>> > > LOGIN_TYPE = WINDOWS,
>> > > SESSION_TIMEOUT = 100,
>> > > DATABASE = 'Northwind',
>> > > NAMESPACE = 'www.codeproject.com',
>> > > CHARACTER_SET = XML
>> > > )




-- 
Gary Kjos
garykjos at gmail.com