CREATE ENDPOINT

Create an endpoint and set properties.

Syntax
      CREATE ENDPOINT endPoint [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 } ]
    [[ , ] COMPRESSION = { ENABLED | DISABLED } ]
    )

AS TCP_protocol_specific_arguments
  AS TCP (
    LISTENER_PORT = listenerPort
    [[ , ] LISTENER_IP = ALL | ( 4-part-ip ) | ( "ip_address_v6" ) ]
  )

FOR SOAP_language_specific_arguments
  FOR SOAP(
    [{ WEBMETHOD [ 'namespace' .] 'method_alias' 
      (   NAME = 'database.schema.name'
        [[ , ] SCHEMA = { NONE | STANDARD | DEFAULT } ]
        [[ , ] FORMAT = { ALL_RESULTS | ROWSETS_ONLY | NONE } ]
      )  
    }[ ,...n ] ]
    [[ , ] BATCHES = { ENABLED | DISABLED } ]
    [[ , ] WSDL = { NONE | DEFAULT | 'sp_name' } ]
    [[ , ] SESSIONS = { ENABLED | DISABLED } ]
    [[ , ] LOGIN_TYPE = { MIXED | WINDOWS } ]
    [[ , ] SESSION_TIMEOUT = timeoutInterval | NEVER ]
    [[ , ] DATABASE = { 'database' | DEFAULT }
    [[ , ] NAMESPACE = { 'namespace' | DEFAULT } ]
    [[ , ] SCHEMA = { NONE | STANDARD } ]
    [[ , ] CHARACTER_SET = { SQL | XML } ]
    [[ , ] HEADER_LIMIT = int ]
  )


FOR SERVICE_BROKER_language_specific_arguments
  FOR SERVICE_BROKER (
     [AUTHENTICATION = { 
              WINDOWS [ { NTLM | KERBEROS | NEGOTIATE } ] 
        | CERTIFICATE certificate 
        | WINDOWS [ { NTLM | KERBEROS | NEGOTIATE } ] CERTIFICATE certificate 
        | CERTIFICATE certificate WINDOWS [ { NTLM | KERBEROS | NEGOTIATE } ] 
      }]
     [[ , ] ENCRYPTION = { DISABLED | { { SUPPORTED | REQUIRED } 
         [ ALGORITHM { RC4 | AES | AES RC4 | RC4 AES } ] } 
     ]
     [[ , ] MESSAGE_FORWARDING = { ENABLED | DISABLED* } ]
     [[ , ] MESSAGE_FORWARD_SIZE = forward_size ]
  )

FOR DATABASE_MIRRORING_language_specific_arguments
FOR DATABASE_MIRRORING (
   [ AUTHENTICATION = { 
            WINDOWS [ { NTLM | KERBEROS | NEGOTIATE } ] 
      | CERTIFICATE certificate 
      | WINDOWS [ { NTLM | KERBEROS | NEGOTIATE } ] CERTIFICATE certificate 
      | CERTIFICATE certificate WINDOWS [ { NTLM | KERBEROS | NEGOTIATE } ] 
   [ [ [ , ] ] ENCRYPTION = { DISABLED | { { SUPPORTED | REQUIRED } 
       [ ALGORITHM { RC4 | AES | AES RC4 | RC4 AES } ] } 

    ] 
   [ , ] ROLE = { WITNESS | PARTNER | ALL }
)

The options above allow a choice of transport protocol - either TCP or HTTP & listening port number,
and the payload language - SOAP, Transact-SQL, service broker or database mirroring.

Key:

AUTHORIZATION - A valid SQL Server or Windows login that is assigned ownership of the newly created endpoint object.

STATE - The state of the endpoint when it is created, to change, use ALTER ENDPOINT

PATH = 'url' - For a URL like http://Server01/Folder02, The Path URL is /Folder02

SITE = webSite a specific host name for the computer.
SITE = + all possible host names for the computer.
SITE = * all possible host names for the computer that are not otherwise explicitly reserved.

COMPRESSION - If enabled, SQL Server will honor requests where gzip encoding is accepted.

BATCHES - Support for ad hoc SQL requests on the endpoint.

LOGIN_TYPE - SQL or WINDOWS authentication.

SESSIONS - If ENABLED, multiple SOAP request/response message pairs can be identified as part of a single SOAP session.

SESSION_TIMEOUT - Time in Seconds before a SOAP session expires.

NAMESPACE - The namespace for the endpoint. The default is http://tempuri.org

HEADER_LIMIT - Max size, in bytes, of the SOAP envelope header.

ENCRYPTION - Negotiate for an encryption algorithm, AES RC4 = give preference to AES while RC4 AES = give preference to RC4.

The default clear port number is 80, the default SSL port number is 443.
Listener port = any number between 1024 and 32767, by convention, 4022.

"La vie est vaine: Un peu d'amour, Un peu de haine, Et puis - Bonjour!" ~ Leon Montenaeken

Related:

ALTER ENDPOINT
DROP ENDPOINT
EVENTDATA


© Copyright SS64.com 1999-2014
Some rights reserved