Skip to content

Commit c5e33ec

Browse files
Change SSLto TLS.
1 parent 23466d7 commit c5e33ec

5 files changed

Lines changed: 6 additions & 6 deletions

File tree

docs/relational-databases/database-mail/database-mail-configuration-objects.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -77,7 +77,7 @@ ms.author: sstein
7777

7878
- The port number of the e-mail server.
7979

80-
- A bit column indicating whether the connection to the SMTP mail server is made using Secure Sockets Layer (SSL).
80+
- A bit column indicating whether the connection to the SMTP mail server is made using Transport Layer Security (TLS), previously known as Secure Sockets Layer (SSL).
8181

8282
- A bit column indicating whether the connection to the SMTP server is made using the credentials configured for the [!INCLUDE[ssDEnoversion](../../includes/ssdenoversion-md.md)].
8383

docs/relational-databases/event-classes/audit-broker-login-event-class.md

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -27,14 +27,14 @@ monikerRange: "=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversio
2727
|**EventClass**|**int**|The type of event class captured. Always **159** for **Audit Broker Login**.|27|No|
2828
|**EventSequence**|**int**|Sequence number for this event.|51|No|
2929
|**EventSubClass**|**int**|The type of event subclass, providing further information about each event class. The table below lists the event subclass values for this event.|21|Yes|
30-
|**FileName**|**nvarchar**|Remote broker authentication level. Supported authentication method configured on the remote broker endpoint. When more than one method is available, the accepting (target) endpoint determines which method is tried first. Possible values are:<br /><br /> **None**. No authentication method is configured.<br /><br /> **NTLM**. Requires NTLM authentication.<br /><br /> **KERBEROS**. Requires Kerberos authentication.<br /><br /> **NEGOTIATE**. Windows negotiates the authentication method.<br /><br /> **CERTIFICATE**. Requires the certificate configured for the endpoint, which is stored in the **master** database.<br /><br /> **NTLM, CERTIFICATE**. Accepts NTLM or SSL certificate authentication.<br /><br /> **KERBEROS, CERTIFICATE**. Accepts Kerberos or the endpoint certificate authentication.<br /><br /> **NEGOTIATE, CERTIFICATE**. Windows negotiates the authentication method or an endpoint certificate can be used for authentication.<br /><br /> **CERTIFICATE, NTLM**. Accepts an endpoint certificate or NTLM for authentication.<br /><br /> **CERTIFICATE, KERBEROS**. Accepts an endpoint certificate or Kerberos for authentication.<br /><br /> **CERTIFICATE, NEGOTIATE**. Accepts an endpoint certificate for authentication or Windows negotiates the authentication method..|36|No|
30+
|**FileName**|**nvarchar**|Remote broker authentication level. Supported authentication method configured on the remote broker endpoint. When more than one method is available, the accepting (target) endpoint determines which method is tried first. Possible values are:<br /><br /> **None**. No authentication method is configured.<br /><br /> **NTLM**. Requires NTLM authentication.<br /><br /> **KERBEROS**. Requires Kerberos authentication.<br /><br /> **NEGOTIATE**. Windows negotiates the authentication method.<br /><br /> **CERTIFICATE**. Requires the certificate configured for the endpoint, which is stored in the **master** database.<br /><br /> **NTLM, CERTIFICATE**. Accepts NTLM or TLS/SSL certificate authentication.<br /><br /> **KERBEROS, CERTIFICATE**. Accepts Kerberos or the endpoint certificate authentication.<br /><br /> **NEGOTIATE, CERTIFICATE**. Windows negotiates the authentication method or an endpoint certificate can be used for authentication.<br /><br /> **CERTIFICATE, NTLM**. Accepts an endpoint certificate or NTLM for authentication.<br /><br /> **CERTIFICATE, KERBEROS**. Accepts an endpoint certificate or Kerberos for authentication.<br /><br /> **CERTIFICATE, NEGOTIATE**. Accepts an endpoint certificate for authentication or Windows negotiates the authentication method..|36|No|
3131
|**HostName**|**nvarchar**|Unused in this event class.|8|Yes|
3232
|**IsSystem**|**int**|Indicates whether the event occurred on a system process or a user process. 1 = system, 0 = user.|60|No|
3333
|**LoginSid**|**image**|The security identification number (SID) of the logged-in user. Each SID is unique for each login in the server.|41|Yes|
3434
|**NTDomainName**|**nvarchar**|The Windows domain to which the user belongs.|7|Yes|
3535
|**NTUserName**|**nvarchar**|The name of the user that owns the connection that generated this event.|6|Yes|
3636
|**ObjectName**|**nvarchar**|The connect string used for this connection.|34|No|
37-
|**OwnerName**|**nvarchar**|Supported authentication method configured on the local broker endpoint. When more than one method is available, the accepting (target) endpoint determines which method is tried first. Possible values are:<br /><br /> **None**. No authentication method is configured.<br /><br /> **NTLM**. Requires NTLM authentication.<br /><br /> **KERBEROS**. Requires Kerberos authentication.<br /><br /> **NEGOTIATE**. Windows negotiates the authentication method.<br /><br /> **CERTIFICATE**. Requires the certificate configured for the endpoint, which is stored in the **master** database.<br /><br /> **NTLM, CERTIFICATE**. Accepts NTLM or SSL certificate authentication.<br /><br /> **KERBEROS, CERTIFICATE**. Accepts Kerberos or the endpoint certificate authentication.<br /><br /> **NEGOTIATE, CERTIFICATE**. Windows negotiates the authentication method or an endpoint certificate can be used for authentication.<br /><br /> **CERTIFICATE, NTLM**. Accepts an endpoint certificate or for NTLM authentication.<br /><br /> **CERTIFICATE, KERBEROS**. Accepts an endpoint certificate or Kerberos for authentication.<br /><br /> **CERTIFICATE, NEGOTIATE**. Accepts an endpoint certificate for authentication or Windows negotiates the authentication method..|37|No|
37+
|**OwnerName**|**nvarchar**|Supported authentication method configured on the local broker endpoint. When more than one method is available, the accepting (target) endpoint determines which method is tried first. Possible values are:<br /><br /> **None**. No authentication method is configured.<br /><br /> **NTLM**. Requires NTLM authentication.<br /><br /> **KERBEROS**. Requires Kerberos authentication.<br /><br /> **NEGOTIATE**. Windows negotiates the authentication method.<br /><br /> **CERTIFICATE**. Requires the certificate configured for the endpoint, which is stored in the **master** database.<br /><br /> **NTLM, CERTIFICATE**. Accepts NTLM or TLS/SSL certificate authentication.<br /><br /> **KERBEROS, CERTIFICATE**. Accepts Kerberos or the endpoint certificate authentication.<br /><br /> **NEGOTIATE, CERTIFICATE**. Windows negotiates the authentication method or an endpoint certificate can be used for authentication.<br /><br /> **CERTIFICATE, NTLM**. Accepts an endpoint certificate or for NTLM authentication.<br /><br /> **CERTIFICATE, KERBEROS**. Accepts an endpoint certificate or Kerberos for authentication.<br /><br /> **CERTIFICATE, NEGOTIATE**. Accepts an endpoint certificate for authentication or Windows negotiates the authentication method..|37|No|
3838
|**ProviderName**|**nvarchar**|The authentication method used for this connection|46|No|
3939
|**RoleName**|**nvarchar**|The role of the connection. This is either **initiator** or **target**.|38|No|
4040
|**ServerName**|**nvarchar**|The name of the instance of SQL Server being traced.|26|No|

docs/relational-databases/system-stored-procedures/sp-addmergepullsubscription-agent-transact-sql.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -313,7 +313,7 @@ sp_addmergepullsubscription_agent [ [ @name = ] 'name' ]
313313
|**1** (default)|Windows Integrated Authentication is used.|
314314

315315
> [!NOTE]
316-
> We recommend using Basic Authentication with Web synchronization. To use Web synchronization, you must make an SSL connection to the Web server. For more information, see [Configure Web Synchronization](../../relational-databases/replication/configure-web-synchronization.md).
316+
> We recommend using Basic Authentication with Web synchronization. To use Web synchronization, you must make a TLS connection to the Web server. For more information, see [Configure Web Synchronization](../../relational-databases/replication/configure-web-synchronization.md).
317317
318318
`[ @internet_timeout = ] internet_timeout`
319319
Is the length of time, in seconds, before a Web synchronization request expires. *internet_timeout* is **int**, with a default of **300** seconds.

docs/relational-databases/system-stored-procedures/sp-change-subscription-properties-transact-sql.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -84,7 +84,7 @@ sp_change_subscription_properties [ @publisher = ] 'publisher'
8484
|**internet_login**||Login that the Merge Agent uses when connecting to the Web server that is hosting Web synchronization using Basic Authentication.|
8585
|**internet_password**||Password that the Merge Agent uses when connecting to the Web server that is hosting Web synchronization using Basic Authentication.|
8686
|**internet_security_mode**|**1**|Use Windows Integrated Authentication for Web synchronization. We recommend using Basic Authentication with Web synchronization. For more information, see [Configure Web Synchronization](../../relational-databases/replication/configure-web-synchronization.md).|
87-
||**0**|Use Basic Authentication for Web synchronization.<br /><br /> Note: Web synchronization requires an SSL connection to the Web server.|
87+
||**0**|Use Basic Authentication for Web synchronization.<br /><br /> Note: Web synchronization requires a TLS connection to the Web server.|
8888
|**internet_timeout**||Length of time, in seconds, before a Web synchronization request expires.|
8989
|**internet_url**||URL that represents the location of the replication listener for Web synchronization.|
9090
|**merge_job_login**||Login for the Windows account under which the agent runs.|

docs/relational-databases/system-stored-procedures/sysmail-help-account-sp-transact-sql.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -59,7 +59,7 @@ sysmail_help_account_sp [ [ @account_id = ] account_id | [ @account_name = ] 'ac
5959
|**port**|**int**|The port number of the e-mail server uses.|
6060
|**username**|**nvarchar(128)**|The user name to use to sign in to the e-mail server, if the e-mail server uses authentication. When **username** is NULL, Database Mail does not use authentication for this account.|
6161
|**use_default_credentials**|**bit**|Specifies whether to send the mail to the SMTP server using the credentials of the [!INCLUDE[ssDEnoversion](../../includes/ssdenoversion-md.md)]. **use_default_credentials** is bit, with no default. When this parameter is 1, Database Mail uses the credentials of the [!INCLUDE[ssDEnoversion](../../includes/ssdenoversion-md.md)] service. When this parameter is 0, Database Mail uses the **\@username** and **\@password** for authentication on the SMTP server. If **\@username** and **\@password** are NULL, then Database Mail uses anonymous authentication. Consult you SMTP administrator before specifying this parameter.|
62-
|**enable_ssl**|**bit**|Specifies whether Database Mail encrypts communication using Secure Sockets Layer (SSL). Use this option if SSL is required on your SMTP server. **enable_ssl** is bit, with no default. 1 indicates Database Mail encrypts communication using SSL. 0 indicates Database Mail sends the mail without SSL encryption.|
62+
|**enable_ssl**|**bit**|Specifies whether Database Mail encrypts communication using Transport Layer Security (TLS), previously known as Secure Sockets Layer (SSL). Use this option if TLS is required on your SMTP server. **enable_ssl** is bit, with no default. 1 indicates Database Mail encrypts communication using TLS. 0 indicates Database Mail sends the mail without TLS encryption.|
6363

6464
## Remarks
6565
When no *account_id* or *account_name* is provided, **sysmail_help_account** lists information on all Database Mail accounts in the Microsoft SQL Server instance.

0 commit comments

Comments
 (0)