KB-1922 Unable to add SQL Server data source from Admin Console due to "Failed datasource validation"

Symptoms

From the Admin Console, a user is unable to add a SQL Server data source hosted in Microsoft Azure Cloud. The following error is printed in the tomcat-stdOut.log located in the <APPIAN_HOME>/logs directory:

DEBUG com.appiancorp.rdbms.datasource.DataSourceFactory - Successfully created Data Source from DataSourceInfo{id=null, uuid='null', name='jdbc/<schema_name>', type=SQL Server, connectionUrl='jdbc:sqlserver://<database_url>:1433;database=<database_name>;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;authenticationMode=ActiveDirectoryPassword'}. Total Data Sources created: 88
ERROR com.appiancorp.expr.server.scriptingfunctions.DataSourceFunctions - Failed datasource validation
com.appiancorp.rdbms.datasource.DataSourceValidationException: java.sql.SQLException: Cannot create PoolableConnectionFactory (Cannot open server "<server_name>" requested by the login.  The login failed. ClientConnectionId:08642aef-2dd8-4c2a-8e04-ae2db07b8ae8)
Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (Cannot open server "<server_name>" requested by the login.  The login failed. ClientConnectionId:08642aef-2dd8-4c2a-8e04-ae2db07b8ae8)
...
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open server "<server_name>" requested by the login.  The login failed. ClientConnectionId:08642aef-2dd8-4c2a-8e04-ae2db07b8ae8

Cause

The logged in user attempting to configure the data source connection is unable to authenticate against the active directory.

Action

Any one of the following steps can resolve the issue:

Engage the Microsoft Active Directory (AD) team to resolve the authentication issue and ensure that the user attempting to connect to the data source has the appropriate permissions.
Disable Active Directory (AD) authentication and use SQL Server authentication instead of authentication on the Azure Console or on the database server.

Affected Versions

This article applies to all versions of Appian.

Last Reviewed: August 2020