how to connect Azure synpase service to data factory

Question

I'm trying to connect synapase to data factory through linked service for copy data. I have created a dedicated SQL pool but when I try to select the sql server its not selecting why ? I got error this (Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'synpase0045.sql.azuresynapse.net', Database: 'synpase0045', User: 'sqladminuser'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.

Login failed for user 'sqladminuser'., SqlErrorNumber=18456,Class=14,State=1,

)
I'm unable to select SQL Pool

Answer 1

In Azure Data Factory, go to the "Manage" tab and then to "Linked Services".

Click on “New” to create a new linked service and select Azure Synapse Analytics (formerly SQL DW) from the list of data stores.

Put the necessary information such as the name of your Azure Synapse Analytics, server name, database name, and authentication type. In your case, it seems like you've chosen SQL authentication.

Enter the username and password for your Azure Synapse Analytics SQL pool.

The error you have indicates a possible issue with the credentials (username or password) provided, or it could be a problem with the firewall settings that prevent access to the SQL pool from Azure Data Factory's integration runtime.