Status: Open (View Workflow)
Affects Version/s: Alfresco Process Services 22.214.171.124
Fix Version/s: Alfresco Process Services .N
Component/s: APS Kickstart/Studio
MS SQL Server v14
Introduce support for MS SQL Data Source using windows authentication login.
Steps to reproduce
1. Install MS SQL server
2. Provide the required MS SQL JDBC driver for activiti-app
3. As admin in activiti-app add a new data source via "Identity Management" -> "Tenants" -> "Data Source":
4. Click "Test connection"
Test fails with message "Login failed for user 'domainAD\loginID'. ClientConnectionId:08526f30-f827-476a-a9c7-db517338acaa"
In APS logs:
In TCP dump:
The cause of the issue is the userName being (MS SQL login ID) in "domain\loginID" format using windows authentication.
What happens is that APS auto-escapes a "\" character with "\" resulting in the actual value of userName as "domain
loginID" being sent to MS SQL Server for authentication from APS->IDM->Data Source->Test Connection.
The connection test should be successful.