SQL Server 数据库 CREATE ENDPOINT 创建端点语法

摘要：

本文将深入探讨SQL Server数据库中创建端点的语法——CREATE ENDPOINT。端点（Endpoint）是SQL Server用于网络通信的接口，它允许客户端通过网络与SQL Server进行交互。本文将详细解析CREATE ENDPOINT语句的各个组成部分，并提供实际应用案例，帮助读者更好地理解和应用这一重要功能。

一、

随着网络技术的发展，SQL Server数据库的远程访问需求日益增长。为了实现客户端与SQL Server之间的安全、高效通信，SQL Server提供了端点（Endpoint）这一功能。端点作为SQL Server的网络通信接口，允许客户端通过网络协议（如TCP/IP、HTTP等）与数据库进行交互。本文将围绕CREATE ENDPOINT语句展开，详细介绍其语法、参数和实际应用。

二、CREATE ENDPOINT语法解析

CREATE ENDPOINT语句用于创建一个端点，以下是CREATE ENDPOINT语句的基本语法：

```sql

CREATE ENDPOINT [endpoint_name]

(

AS [TCP/IP] (

[protocol =] protocol_value,

[address =] address_value,

[port =] port_value

)

| AS [HTTP] (

[protocol =] protocol_value,

[address =] address_value,

[port =] port_value

)

| AS [WSHTTP] (

[protocol =] protocol_value,

[address =] address_value,

[port =] port_value

)

[FOR [TCP/IP] | [HTTP] | [WSHTTP]]

(

[STATE =] state_value

[ALLOW =] allow_value

[PORT =] port_value

[ADDRESS =] address_value

[STATISTICS =] statistics_value

[STARTUP =] startup_value

[CERT =] cert_value

[ASYNC =] async_value

[METH =] method_value

[PATH =] path_value

[AUTH =] auth_value

[CERT_ENCRYPT =] cert_encrypt_value

[CERT_AUTH =] cert_auth_value

[CERT_AUTHENT =] cert_authent_value

[CERT_ENCRYPT_ALGORITHM =] cert_encrypt_algorithm_value

[CERT_AUTH_ALGORITHM =] cert_auth_algorithm_value

[CERT_AUTHENT_ALGORITHM =] cert_authent_algorithm_value

[CERT_SUBJECT =] cert_subject_value

[CERT_ISSUER =] cert_issuer_value

[CERT_NOT_AFTER =] cert_not_after_value

[CERT_NOT_BEFORE =] cert_not_before_value

[CERT_EXPIRED =] cert_expired_value

[CERT_REVOKED =] cert_revoked_value

[CERT_SUBJECT_NAME =] cert_subject_name_value

[CERT_ISSUER_NAME =] cert_issuer_name_value

[CERT_NOT_AFTER_NAME =] cert_not_after_name_value

[CERT_NOT_BEFORE_NAME =] cert_not_before_name_value

[CERT_EXPIRED_NAME =] cert_expired_name_value

[CERT_REVOKED_NAME =] cert_revoked_name_value

[CERT_SUBJECT_LOCAL_NAME =] cert_subject_local_name_value

[CERT_ISSUER_LOCAL_NAME =] cert_issuer_local_name_value

[CERT_NOT_AFTER_LOCAL_NAME =] cert_not_after_local_name_value

[CERT_NOT_BEFORE_LOCAL_NAME =] cert_not_before_local_name_value

[CERT_EXPIRED_LOCAL_NAME =] cert_expired_local_name_value

[CERT_REVOKED_LOCAL_NAME =] cert_revoked_local_name_value

[CERT_SUBJECT_ORGANIZATION =] cert_subject_organization_value

[CERT_ISSUER_ORGANIZATION =] cert_issuer_organization_value

[CERT_NOT_AFTER_ORGANIZATION =] cert_not_after_organization_value

[CERT_NOT_BEFORE_ORGANIZATION =] cert_not_before_organization_value

[CERT_EXPIRED_ORGANIZATION =] cert_expired_organization_value

[CERT_REVOKED_ORGANIZATION =] cert_revoked_organization_value

[CERT_SUBJECT_EMAIL =] cert_subject_email_value

[CERT_ISSUER_EMAIL =] cert_issuer_email_value

[CERT_NOT_AFTER_EMAIL =] cert_not_after_email_value

[CERT_NOT_BEFORE_EMAIL =] cert_not_before_email_value

[CERT_EXPIRED_EMAIL =] cert_expired_email_value

[CERT_REVOKED_EMAIL =] cert_revoked_email_value

[CERT_SUBJECT_COUNTRY =] cert_subject_country_value

[CERT_ISSUER_COUNTRY =] cert_issuer_country_value

[CERT_NOT_AFTER_COUNTRY =] cert_not_after_country_value

[CERT_NOT_BEFORE_COUNTRY =] cert_not_before_country_value

[CERT_EXPIRED_COUNTRY =] cert_expired_country_value

[CERT_REVOKED_COUNTRY =] cert_revoked_country_value

[CERT_SUBJECT_STATE_OR_PROVINCE =] cert_subject_state_or_province_value

[CERT_ISSUER_STATE_OR_PROVINCE =] cert_issuer_state_or_province_value

[CERT_NOT_AFTER_STATE_OR_PROVINCE =] cert_not_after_state_or_province_value

[CERT_NOT_BEFORE_STATE_OR_PROVINCE =] cert_not_before_state_or_province_value

[CERT_EXPIRED_STATE_OR_PROVINCE =] cert_expired_state_or_province_value

[CERT_REVOKED_STATE_OR_PROVINCE =] cert_revoked_state_or_province_value

[CERT_SUBJECT_LOCALITY =] cert_subject_locality_value

[CERT_ISSUER_LOCALITY =] cert_issuer_locality_value

[CERT_NOT_AFTER_LOCALITY =] cert_not_after_locality_value

[CERT_NOT_BEFORE_LOCALITY =] cert_not_before_locality_value

[CERT_EXPIRED_LOCALITY =] cert_expired_locality_value

[CERT_REVOKED_LOCALITY =] cert_revoked_locality_value

[CERT_SUBJECT_STREET_ADDRESS =] cert_subject_street_address_value

[CERT_ISSUER_STREET_ADDRESS =] cert_issuer_street_address_value

[CERT_NOT_AFTER_STREET_ADDRESS =] cert_not_after_street_address_value

[CERT_NOT_BEFORE_STREET_ADDRESS =] cert_not_before_street_address_value

[CERT_EXPIRED_STREET_ADDRESS =] cert_expired_street_address_value

[CERT_REVOKED_STREET_ADDRESS =] cert_revoked_street_address_value

[CERT_SUBJECT_POBOX =] cert_subject_po_box_value

[CERT_ISSUER_POBOX =] cert_issuer_po_box_value

[CERT_NOT_AFTER_POBOX =] cert_not_after_po_box_value

[CERT_NOT_BEFORE_POBOX =] cert_not_before_po_box_value

[CERT_EXPIRED_POBOX =] cert_expired_po_box_value

[CERT_REVOKED_POBOX =] cert_revoked_po_box_value

[CERT_SUBJECT_SERIAL_NUMBER =] cert_subject_serial_number_value

[CERT_ISSUER_SERIAL_NUMBER =] cert_issuer_serial_number_value

[CERT_NOT_AFTER_SERIAL_NUMBER =] cert_not_after_serial_number_value

[CERT_NOT_BEFORE_SERIAL_NUMBER =] cert_not_before_serial_number_value

[CERT_EXPIRED_SERIAL_NUMBER =] cert_expired_serial_number_value

[CERT_REVOKED_SERIAL_NUMBER =] cert_revoked_serial_number_value

[CERT_SUBJECT_SUBJECT_ALGORITHM =] cert_subject_subject_algorithm_value

[CERT_ISSUER_SUBJECT_ALGORITHM =] cert_issuer_subject_algorithm_value

[CERT_NOT_AFTER_SUBJECT_ALGORITHM =] cert_not_after_subject_algorithm_value

[CERT_NOT_BEFORE_SUBJECT_ALGORITHM =] cert_not_before_subject_algorithm_value

[CERT_EXPIRED_SUBJECT_ALGORITHM =] cert_expired_subject_algorithm_value

[CERT_REVOKED_SUBJECT_ALGORITHM =] cert_revoked_subject_algorithm_value

[CERT_ISSUER_SUBJECT_ALGORITHM =] cert_issuer_subject_algorithm_value

[CERT_SUBJECT_ISSUER_ALGORITHM =] cert_subject_issuer_algorithm_value

[CERT_NOT_AFTER_ISSUER_ALGORITHM =] cert_not_after_issuer_algorithm_value

[CERT_NOT_BEFORE_ISSUER_ALGORITHM =] cert_not_before_issuer_algorithm_value

[CERT_EXPIRED_ISSUER_ALGORITHM =] cert_expired_issuer_algorithm_value

[CERT_REVOKED_ISSUER_ALGORITHM =] cert_revoked_issuer_algorithm_value

[CERT_SUBJECT_KEY_ALGORITHM =] cert_subject_key_algorithm_value

[CERT_ISSUER_KEY_ALGORITHM =] cert_issuer_key_algorithm_value

[CERT_NOT_AFTER_KEY_ALGORITHM =] cert_not_after_key_algorithm_value

[CERT_NOT_BEFORE_KEY_ALGORITHM =] cert_not_before_key_algorithm_value

[CERT_EXPIRED_KEY_ALGORITHM =] cert_expired_key_algorithm_value

[CERT_REVOKED_KEY_ALGORITHM =] cert_revoked_key_algorithm_value

[CERT_SUBJECT_KEY_SIZE =] cert_subject_key_size_value

[CERT_ISSUER_KEY_SIZE =] cert_issuer_key_size_value

[CERT_NOT_AFTER_KEY_SIZE =] cert_not_after_key_size_value

[CERT_NOT_BEFORE_KEY_SIZE =] cert_not_before_key_size_value

[CERT_EXPIRED_KEY_SIZE =] cert_expired_key_size_value

[CERT_REVOKED_KEY_SIZE =] cert_revoked_key_size_value

[CERT_SUBJECT_PUBLIC_KEY_HASH =] cert_subject_public_key_hash_value

[CERT_ISSUER_PUBLIC_KEY_HASH =] cert_issuer_public_key_hash_value

[CERT_NOT_AFTER_PUBLIC_KEY_HASH =] cert_not_after_public_key_hash_value

[CERT_NOT_BEFORE_PUBLIC_KEY_HASH =] cert_not_before_public_key_hash_value

[CERT_EXPIRED_PUBLIC_KEY_HASH =] cert_expired_public_key_hash_value

[CERT_REVOKED_PUBLIC_KEY_HASH =] cert_revoked_public_key_hash_value

[CERT_SUBJECT_PUBLIC_KEY_INFO =] cert_subject_public_key_info_value

[CERT_ISSUER_PUBLIC_KEY_INFO =] cert_issuer_public_key_info_value

[CERT_NOT_AFTER_PUBLIC_KEY_INFO =] cert_not_after_public_key_info_value

[CERT_NOT_BEFORE_PUBLIC_KEY_INFO =] cert_not_before_public_key_info_value

[CERT_EXPIRED_PUBLIC_KEY_INFO =] cert_expired_public_key_info_value

[CERT_REVOKED_PUBLIC_KEY_INFO =] cert_revoked_public_key_info_value

[CERT_SUBJECT_SUBJECT_KEY_IDENTIFIER =] cert_subject_subject_key_identifier_value

[CERT_ISSUER_SUBJECT_KEY_IDENTIFIER =] cert_issuer_subject_key_identifier_value

[CERT_NOT_AFTER_SUBJECT_KEY_IDENTIFIER =] cert_not_after_subject_key_identifier_value

[CERT_NOT_BEFORE_SUBJECT_KEY_IDENTIFIER =] cert_not_before_subject_key_identifier_value

[CERT_EXPIRED_SUBJECT_KEY_IDENTIFIER =] cert_expired_subject_key_identifier_value

[CERT_REVOKED_SUBJECT_KEY_IDENTIFIER =] cert_revoked_subject_key_identifier_value

[CERT_ISSUER_SUBJECT_KEY_IDENTIFIER =] cert_issuer_subject_key_identifier_value

[CERT_SUBJECT_ISSUER_KEY_IDENTIFIER =] cert_subject_issuer_key_identifier_value

[CERT_NOT_AFTER_ISSUER_KEY_IDENTIFIER =] cert_not_after_issuer_key_identifier_value