3780342 - Unable to create Azure SQL live connection using ActiveDirectoryServicePrincipal with error "failed to prepare connection for live data capability, invalid connection properties" - SAP Analytics Cloud

• Unable to create Azure SQL connection using ActiveDirectoryServicePrincipal.
• The error message: Failed to prepare connection for live data capability. Invalid connection properties.
• Connection to the same database works via other routes, like SSMS.
• Import data connection works.

SAP Analytics Cloud 2026.8.10 

1. In the side navigation, choose Connections, then select Add Connection.
2. Choose Azure SQL.
3. Enter a connection name.
4. Enter a description.
5. In Server and port, enter the server name and port of the Azure SQL database.
6. Enter credentials appropriate for the selected authentication method.
7. In Database, enter the database name.
8. Choose OK.

An input validation is being triggered in the password field. Certain characters and character combinations trigger this, such as:

•  --
• ,
• /*
• ' and "

Please check whether the password contains any characters or character combinations such as "--", "/*", or quotation marks (' or ").

If so, change the password so that it no longer contains any of these characters and try again.

Live Data Connections to Azure SQL | SAP Help Portal

azure sql, live data connection, activedirectoryserviceprincipal, invalid connection properties, failed to prepare connection, sac connection error, ssms works sac fails, azure sql live, authentication, connection creation, sac azure sql live connection , KBA , LOD-ANA-LDC-SQL , SAC Live Data Connection SQL , LOD-ANA-LDC , SAC Live Data Connection , Bug Filed