Post reply

Understanding endpoint creation (authentication)

  • March 22, 2016 at 10:59 am

    #314225

    Hi all,

    My understanding of an endpoint is a point of connection for external clients to connect to the SQL server instance.

    and different kind of endpoint(payload) can be created e.g (db mirroring) - am i right ?

    I am particularly confused about the authorization parameter of the CREATE ENDPOINT statement

    AUTHENTICATION = <authentication_options>

    Specifies the TCP/IP authentication requirements for connections for this endpoint. The default is WINDOWS.

    <authentication_options> ::=

    WINDOWS [ { NTLM | KERBEROS | NEGOTIATE } ]

    Specifies that the endpoint is to connect using Windows Authentication protocol to authenticate the endpoints. This is the default.

    Specifies the TCP/IP authentication requirements for connections for this endpoint.

    Does the "for" actually means "to" ?

    -- means that client connections to this endpoint must be authenticated with the above authentication options ?

    Regards,

    Confused Noob

  • March 22, 2016 at 1:33 pm

    #1866931

    szejiekoh (3/22/2016)

    Hi all,

    Specifies the TCP/IP authentication requirements for connections for this endpoint.

    Does the "for" actually means "to" ?

    -- means that client connections to this endpoint must be authenticated with the above authentication options ?

    Likely just an editing error, as it makes sense written as either

    Specifies the TCP/IP authentication requirements for this endpoint.

    or

    Specifies the TCP/IP authentication requirements for connections to this endpoint.

    Eddie Wuerch
    MCM: SQL

  • March 22, 2016 at 8:50 pm

    #1866983

    Eddie Wuerch (3/22/2016)

    szejiekoh (3/22/2016)

    Hi all,

    Specifies the TCP/IP authentication requirements for connections for this endpoint.

    Does the "for" actually means "to" ?

    -- means that client connections to this endpoint must be authenticated with the above authentication options ?

    Likely just an editing error, as it makes sense written as either

    Specifies the TCP/IP authentication requirements for this endpoint.

    or

    Specifies the TCP/IP authentication requirements for connections to this endpoint.

    Hi Eddie,

    Thanks for your reply.

    q1) So my understanding that the above parameter "authentication" specifies how client authenticate with the endpoint right ?

    q2) In another sense, I see only Windows does that means client cannot authenticate with the endpoint using SQL server login accounts instead ?

    Regards,

    Noob

  • March 23, 2016 at 8:15 am

    #1867092

    Anyone ;~~):-D

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply