[dba-SQLServer] ) errors

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
> > > )
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > _______________________________________________
> > > dba-SQLServer mailing list
> > > dba-SQLServer at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > > http://www.databaseadvisors.com
> > >
> >
> >
> >
> > --
> > Gary Kjos
> > garykjos at gmail.com
> >
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>