Hi @AinoKaisa
Welcome to the Microsoft Q&A and thank you for posting your questions here.
I understand that you're facing connection issues in Azure Data Factory, especially after successfully setting up the linked service. The error message you’re encountering regarding the "server" property being required for Azure SQL Database is quite common and typically points to a configuration issue.
I suggest trying this approach, which worked for a similar issue I faced:
- Create a new Linked Service using the "legacy" option instead of the "recommended" one.
- Enter your server and database names, then test the connection.
- Once the test is successful, publish the changes.
- After that, update your data sources to use this new Linked Service.
There seems to be a temporary issue with the recommended "new" version of the Linked Service. Using the "legacy" version should resolve the error.
Hope this helps. Do let us know if you any further queries.
If this answers your query, do click Accept Answer
and Yes
for was this answer helpful. And, if you have any further query do let us know.