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

Symptoms

Using the Admin Console, users are unable to add MS SQL 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 "soundphysicians.com" 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

This issue occurs when the logged in user (attempting to configure the data source connection) is unable to authentication against the active directory. 

Action

Any one of the following steps can resolve the issue: 

  1. Engage the Microsoft AD team to resolve the authentication issue and ensure that user used to connect to the datasource has the appropriate permissions. 
  2. Disable Active Directory Authentication and use MS SQL authentication instead on the Azure Console or on the database server.  

Affected Versions

This article applies to all versions of Appian.

Last Reviewed: April 2019

Related
Recommended