SAP Knowledge Base Article - Public

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

Symptom

  • 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.

Environment

SAP Analytics Cloud 2026.8.10 

Reproducing the Issue

  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.

Cause

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

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

Resolution

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.

See Also

Live Data Connections to Azure SQL | SAP Help Portal

Keywords

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

Product

SAP Analytics Cloud all versions