Connecting with Azure Synapse Link

Pankaj_SBS — Mon, 06 Apr 2026 21:23:32 GMT

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.

Re: Connecting with Azure Synapse Link

maartenw — Wed, 15 Apr 2026 06:14:18 GMT

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-engine-error?view=sql-server-ver15

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!

topic Re: Connecting with Azure Synapse Link in Connectivity & Data Prep

Connecting with Azure Synapse Link

Re: Connecting with Azure Synapse Link