Export (0) Print
Expand All

sys.http_endpoints (Transact-SQL)

Contains a row for each endpoint created in the server that uses the HTTP protocol.

Applies to: SQL Server (SQL Server 2008 through current version).

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.

The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft