I am trying to retrieve data from a table located in a sql server database on an on-premise server. I would like to inject this data into an Azure SQL Database. I set up the runtime integration. By using data factory, i am able to retrieve data from a table on my on-premises server and have it copied to another table on the same on-premises server. I also manage to copy the data from one azure database table to another azure database table. On the other hand, not from my on premise table to azure database.
I have the following message :
Operation on target Copy data' failed: connect to SQL Database: Database: 'XXXXX', User:
adminXXX'. Check linked service configuration is correct, and make
sure the SQL Database firewall allows the integration runtime to ...
erreur liée au réseau ou spécifique à l'instance s'est produite lors
de rétablissement dune connexion à SQL Server, Le serveur est
introuvable Ou n'est pas accessible, Vérifiez que le de l'instance est
correct et que SQL Server est configuré pour autoriser les ....
.Net
SqlClient Data Provider, SQLErrorNumber=10060, Class= 20,
ErrorCode=-2146232060,State=0
I can't find an explanation, the firewall seems to be well configured. An idea?