Using SQL Server 2005's New Web Services Capability : Page 2

Syntax for Creating Endpoints
The full SQL syntax for creating an endpoint is:

   CREATE ENDPOINT endPointName [ AUTHORIZATION login ]
   STATE = { STARTED | STOPPED | DISABLED }
   AS { HTTP | TCP } (
      <protocol_specific_arguments>)
   FOR { SOAP | TSQL | SERVICE_BROKER | 
      DATABASE_MIRRORING } (
      <language_specific_arguments>)
   
   <AS HTTP_protocol_specific_arguments> ::=
   AS HTTP (
     PATH = 'url'
       , AUTHENTICATION =( { BASIC | DIGEST | 
       INTEGRATED | NTLM | KERBEROS } [ ,...n ] )
         , PORTS = ( { CLEAR | SSL} [ ,... n ] )
     [ SITE = {'*' | '+' | 'webSite' },]
     [, CLEAR_PORT = clearPort ]
     [, SSL_PORT = SSLPort ]
     [, AUTH_REALM = { 'realm' | NONE } ]
     [, DEFAULT_LOGON_DOMAIN = { 'domain' | NONE } ]
     [, RESTRICT_IP = { NONE | ALL } ]
     [, COMPRESSION = { ENABLED | DISABLED } ]
     [, EXCEPT_IP = ( { <4-part-ip> | <4-part-ip>:<mask> 
        } [ ,...n ] )
   )
   
   <AS TCP_protocol_specific_arguments> ::=AS TCP (
     LISTENER_PORT = listenerPort
     [ , LISTENER_IP = ALL | (<4-part-ip> | 
        <ip_address_v6> ) ]
     [ , RESTRICT_IP = ALL | NONE ]
     [ , EXCEPT_IP = ( { <4-part-ip> | <4-part-ip>:<mask> 
         } [ ,...n ] ) ]
   
   <FOR SOAP_language_specific_arguments> ::=
   FOR SOAP(
     [ { WEBMETHOD [ 'namespace' .] 'method_alias' 
       (   NAME = 'database.owner.name'
         [ , SCHEMA = { NONE | STANDARD | DEFAULT } ]
         [ , FORMAT = { ALL_RESULTS | ROWSETS_ONLY } ])  
     
     } [ ,...n ] ]
     [   BATCHES = { ENABLED | DISABLED } ]
     [ , WSDL = { NONE | DEFAULT | 'sp_name' } ]
     [ , SESSIONS = { ENABLED | DISABLED } ]
     [ , LOGIN_TYPE = { MIXED | WINDOWS } ]
     [ , SESSION_TIMEOUT = timeoutInterval | NEVER ]
     [ , DATABASE = { 'database_name' | DEFAULT }
     [ , NAMESPACE = { 'namespace' | DEFAULT } ]
     [ , SCHEMA = { NONE | STANDARD } ]
     [ , CHARACTER_SET = { SQL | XML }]
     [ , MAX_SOAP_HEADERS_SIZE = { int | DEFAULT }])
   <FOR SERVICE_BROKER_language_specific_arguments> ::=
   FOR SERVICE_BROKER (
     [ AUTHENTICATION = { WINDOWS* [ { NTLM | KERBEROS | 
        NEGOTIATE* } ] | CERTIFICATE certificateName |
        WINDOWS[ {NTLM|KERBEROS|NEGOTIATE* } ] CERTIFICATE certificateName |
       CERTIFICATE certificateName WINDOWS[ 
       {NTLM|KERBEROS|NEGOTIATE* } ]}]
     [ , ENCRYPTION = {DISABLED|SUPPORTED|REQUIRED*} 
     [ALGORITHM  {RC4*|AES|AES RC4|RC4 AES}]]}
     [ , MESSAGE_FORWARDING = { ENABLED | DISABLED* } ]
     [ , MESSAGE_FORWARD_SIZE = forwardSize ])

After creating an endpoint, you can alter (ALTER ENDPOINT) or drop it (DROP ENDPOINT), as well as grant permissions for it. This article concentrates on SOAP and HTTP, and ignores the options to use TCP, to provide service brokering, and to provide database mirroring.

Previous Page

Next Page

---

• Download The Code for this Article

---