Skip to content

Commit 212dc61

Browse files
yitamyitam
authored
Update azure-active-directory.md
Added ODBC requirements to connecting using access token or managed identities
1 parent 65769b7 commit 212dc61

1 file changed

Lines changed: 4 additions & 4 deletions

File tree

‎docs/connect/php/azure-active-directory.md‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
---
22
title: "Azure Active Directory | Microsoft Docs"
3-
ms.date: "02/11/2019"
3+
ms.date: "02/25/2019"
44
ms.prod: sql
55
ms.prod_service: connectivity
66
ms.custom: ""
@@ -22,11 +22,11 @@ To use Azure AD, use the **Authentication** or **AccessToken** keywords (they ar
2222
|Keyword|Values|Description|
2323
|-|-|-|
2424
|**AccessToken**|Not set (default)|Authentication mode determined by other keywords. For more information, see [Connection Options](../../connect/php/connection-options.md). |
25-
||A byte string|The Azure AD Access Token extracted from an OAuth JSON response. The connection string must not contain user ID, password, or the Authentication keyword. |
25+
||A byte string|The Azure AD Access Token extracted from an OAuth JSON response. The connection string must not contain user ID, password, or the Authentication keyword (requires ODBC Driver version 17 or above in Linux or macOS). |
2626
|**Authentication**|Not set (default)|Authentication mode determined by other keywords. For more information, see [Connection Options](../../connect/php/connection-options.md). |
2727
||`SqlPassword`|Directly authenticate to a SQL Server instance (which may be an Azure instance) using a username and password. The username and password must be passed into the connection string using the **UID** and **PWD** keywords. |
2828
||`ActiveDirectoryPassword`|Authenticate with an Azure Active Directory identity using a username and password. The username and password must be passed into the connection string using the **UID** and **PWD** keywords. |
29-
||`ActiveDirectoryMsi`|Authenticate using either a system-assigned managed identity or a user-assigned managed identity. For an overview and tutorials, refer to [What is managed identities for Azure resources?](https://docs.microsoft.com/azure/active-directory/managed-identities-azure-resources/overview).|
29+
||`ActiveDirectoryMsi`|Authenticate using either a system-assigned managed identity or a user-assigned managed identity (requires ODBC Driver version 17.3.1.1 or above). For an overview and tutorials, refer to [What is managed identities for Azure resources?](https://docs.microsoft.com/azure/active-directory/managed-identities-azure-resources/overview).|
3030

3131
The **Authentication** keyword affects the connection security settings. If it is set in the connection string, then by default the **Encrypt** keyword is set to true, which means the client will request encryption. Moreover, the server certificate will be validated irrespective of the encryption setting unless **TrustServerCertificate** is set to true (**false** by default). This feature is distinguished from the old, less secure login method, in which the server certificate is validated only when encryption is specifically requested in the connection string.
3232

@@ -234,4 +234,4 @@ try {
234234
## See Also
235235
[Using Azure Active Directory with the ODBC Driver](https://docs.microsoft.com/sql/connect/odbc/using-azure-active-directory)
236236

237-
[What is managed identities for Azure resources?](https://docs.microsoft.com/azure/active-directory/managed-identities-azure-resources/overview)
237+
[What is managed identities for Azure resources?](https://docs.microsoft.com/azure/active-directory/managed-identities-azure-resources/overview)

0 commit comments

Comments
 (0)