@Youssef_BenSalem I would recommend using a connection file that gets published with the workflow, or a DSN that is configured on both the user's local machine and on the Server. The following articles contain instructions for both of these methods.
As a best practice, I would recommend utilizing File connections within your server environment and storing the file connection in a network location so that the server/user can access the file connection.
Hope this helps, if it does please like this post and if it helps resolve your problem, mark it as a solution. If you have any other questions, please let us know.
