Forum Discussion
Can't use Folder connector with on-premises data gateway
I did find the solution.
I was focusing on the wrong part. The issue was not from the destination connection but from the source connection.
It is the normal behavior to not be able to tick the option to "Allow this connection to be used with gateways" when you configure a connection going through the gateway.
The connection is implicitly allowed, because you are using a gateway to connect to your on prem network!To solve the issue, check if the source connection is allowed to be used with gateway.
Thanks to anyone who tried to help
Regards
Super UserHi AzGharbi FrozenFritz,
Do you have connection creator permissions on the gateway?
FOr the connection to the lakehouse - don't use the gateway, it's not needed and will only cause problems.
For the connection to the source file, that needs to be a gateway connection to access your on prem env. Creating the connection directly on the gateway in the manage connections and gateways page should allow you to do this.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Hi tayloramy,
thanks for the reply. I do have the permissions to create connections in the settings section. For the source file this is exactly what i've done to get my files from my on prem servers. Any old Copy Jobs which i've created before are working as expected on Connections targeting folder shares on the servers.
The problem occurs on new Copy Jobs ( and i think they changed them as well because the destination part needs now a connection too ) which are using a new connection targeting a folder.
New Copy Job ( which fails )Source settings:
Destination settings:
Errror message:
Old Copy Job on an old connection, created months ago:
Source settings:
Destination settings:
I did find the solution.
I was focusing on the wrong part. The issue was not from the destination connection but from the source connection.
It is the normal behavior to not be able to tick the option to "Allow this connection to be used with gateways" when you configure a connection going through the gateway.
The connection is implicitly allowed, because you are using a gateway to connect to your on prem network!To solve the issue, check if the source connection is allowed to be used with gateway.
Thanks to anyone who tried to help
RegardsInteresting! I it figured out too at the same time! 🥳
I find the error message kind of misleading. Great we both solved our errors 😉
