Error - "System.ArgumentException: Keyword Not Supported: 'Authentication' " While Using Azure AD Authentication To Connect To SQL Server

News Knowledge Base
,
1

Why is it not possible to connect to the Orchestrator database using Azure AD authentication?

While leveraging Azure AD authentication to connect to the Orchestrator database, the following kind of errors may be encountered:

  • System.ArgumentException: Invalid value for key 'authentication'.
  • System.ArgumentException: Keyword not supported: 'authentication'.

Root Cause: This error occurs because of some missing requirements that surround authentication with Azure AD to connect to your SQL DB.

Resolution: Note the following,

  • Use Azure AD Authentication in the SQL connection but it is available only for App Service and Orchestrator on IaaS deployments and not with a password. Integrated AD or AAD should ideally not require a password as the authentication is not done at the SQL instance level. Read more here: Azure AD authentication with SQL Server.
  • Azure AD authentication is available only starting version 2021.10.10 where we switched System.Data with Microsoft.Data SqlClient. Hence, in order to leverage the same, be on an Orchestrator version that is equal to or more than 2021.10.10. Find more information here: v2021.10.10 - SQL client upgrade.

1 Like