[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
>