sys.http_endpoints (Transact-SQL)
Applies to: 
SQL Server
This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Contains a row for each endpoint created in the server that uses the HTTP protocol.
| Column name | Data type | Description |
|---|---|---|
| < inherited columns> | Inherits columns from sys.endpoints (Transact-SQL). | |
| site | nvarchar(128) | Name of the host computer for the site, as specified in the SITE = option. |
| url_path | nvarchar(4000) | Path-only portion of the URL for this HTTP endpoint, as specified by the PATH= option. |
| is_clear_port_enabled | bit | 1 = Clear port is enabled using the PORT = CLEAR option. |
| clear_port | int | Port number specified in the CLEAR PORT = option. NULL = Not specified. |
| is_ssl_port_enabled | bit | 1 = SSL port is enabled using the PORT = SSL option. |
| ssl_port | int | Port number value specified in the SSL PORT = option. NULL = Not specified. |
| is_anonymous_enabled | bit | 1 = Anonymous access is enabled using the AUTHENTICATION = ANONYMOUS option. |
| is_basic_auth_enabled | bit | 1 = Basic authentication is enabled using the AUTHENTICATION = BASIC option. |
| is_digest_auth_enabled | bit | 1 = Digest authentication is enabled using the AUTHENTICATION = DIGEST option. |
| is_kerberos_auth_enabled | bit | 1 = Integrated authentication enabled using the AUTHENTICATION = KERBEROS option. |
| is_ntlm_auth_enabled | bit | 1 = Integrated authentication enabled using the AUTHENTICATION = NTLM option. |
| is_integrated_auth_enabled | bit | 1 = Integrated authentication is enabled using the AUTHENTICATION = INTEGRATED option. |
| authorization_realm | nvarchar(128) | Hint that is returned to the client as part of the HTTP DIGEST authentication challenge. The value of the AUTH REALM option. Is NULL if not specified or if DIGEST authentication is not enabled. |
| default_logon_domain | nvarchar(128) | Default login domain if you enable BASIC authentication. The value of the DEFAULT LOGON DOMAIN option. Is NULL if not specified or if BASIC authentication is not enabled. |
| is_compression_enabled | bit | 1 = COMPRESSION = ENABLED option is set. |
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.
See Also
Catalog Views (Transact-SQL)
Endpoints Catalog Views (Transact-SQL)