Connection Agent to one SQL server from different workspaces

  • 111Views
  • Last Post 4 weeks ago
0
votes
EFC MIS posted this 4 weeks ago

Hello,

I have two different workspaces set up.

I need to have an agent installed on an SQL server that allows access from different workspaces.

I am not sure if this requires me to set up two agents on the server (if so, how do I do that ? , do I just add another key to the key file ?).

Or, is it possible to clone the first agent and copy it to the 2nd workspace.

Thank you.

Tom

0
votes
Serhii Muzyka posted this 4 weeks ago

 Hi,

 

Thank you for contacting Skyvia Support.

 

Unfortunately, it is not possible to add two keys to your agent application. See more about the Agents here: https://docs.skyvia.com/agents.html#managing

Also, at the moment, there is no way to copy objects from one workspace to another.

This feature is on our roadmap. We will definitely inform you when it is released. 

 

For this situation, you can set up a new agent connection by downloading the app and adding the new key on another computer and use it for the new workspace.

The other option is to use the folder function in the same workspace.

You will have a personal space for your packages and will be able to use your agent connection. It is also possible to add a new user to your workspace.

See this documentation to know more about how to add another user to your workspace here: https://docs.skyvia.com/account-management/inviting-and-deleting-users-from-accounts.html

Should you have other questions, don't hesitate to reach out.

 

Best regards,

Serhii

Close