ALTER ENDPOINT

Alter an endpoint - set properties.

Syntax
      ALTER 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 ] ]
 
 [ { ALTER WEBMETHOD [ 'namespace' .] 'method_alias' 
( NAME = 'database.owner.name'
[ , SCHEMA = {NONE | STANDARD | DEFAULT} ]
[ , FORMAT = { ALL_RESULTS | ROWSETS_ONLY } ]
)
} [ ,...n]
] [[ , ] { DROP WEBMETHOD [ 'namespace' .] 'method_alias' } [ ,...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 commands

CREATE ENDPOINT
DROP ENDPOINT
EVENTDATA


 
Copyright © 1999-2024 SS64.com
Some rights reserved