Connecting with Azure Synapse Link

[Pankaj_SBS]

Hello Users,

This is my first time connecting with Dynamics F&O. Dynamics F&O are very rigid and the only possible way I cam across was using Synapse Link.

We created Synapse Link, loaded some tables in the Master Data, gave rights to the users and started creating connection with Qlik.

We are using Azure Synapse Analytics and in that we are using Azure OAuth. We even verified the Tenant ID Azure Link from User. 

But, when we try to do Test Connection, we are getting Error : SQL 18456 : Login failed for user '<token-identified principal>'.

Any user came across such issue, or any solution for the same?

Thanking you in advance for all your support.

Thanks.

[maartenw]

Hi,

The error message 18456 usually indicates an incorrect username or password. See this documentation:
https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-18456-database-...

If the database server requires SQL Server Authentication (username-password), make sure you can log in with this credentials on another SQL Server client

If windows authentication is used, make sure the service account running Qlik Sense Engine services has access tot the database. Hope this helps!