Access issues for MySQL database when Taking over data flow

[k_foxy]

Hi

We have issue with connection to MySQL database.
When myself or my colleague creates data flow in pipeline using existng MySQL connection it works fine. When we use functionality Take Over data flow, the connection stopps working.

Error message. 
We could not evaluate this query due to invalid or missing credentials. 

This is happening for both of us. Even after Take Over I add connection credentials it does not work. Looks like mechanism Take over breaks connection. Is there solution to this?

[Anonymous]

Hi @k_foxy 
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[Anonymous]

Hi @k_foxy 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[k_foxy]

Hi I think I have resolved the issue

[Anonymous]

Hi @k_foxy 
Thank you for reaching out microsoft fabric community forum.

Thanks for the details and the log — this is a known issue where the “Take Over” action can break the connection by removing or not transferring the saved credentials, especially with VNet Gateways and non-SSL MySQL sources.

Since your server doesn’t support SSL, setting the encryption to "Encrypted" won’t work. Instead, after taking over the dataflow, try deleting and recreating the MySQL connection, making sure to set the encryption to “Not Encrypted.” Then rebind the dataflow to this new connection.

Also, check that the VNet Gateway allows non-SSL connections, as it may default to requiring encryption even if the connection says otherwise.

This usually resolves the issue, as the problem stems from credentials being tied to the original owner.

If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community
Thank you.

[nilendraFabric]

Hello @k_foxy 

Sometimes Take Over process doesn’t properly maintain or transfer the connection configuration between owners

If you can access the advanced settings of your data source within the gateway configuration 

Try explicitly set the “Connection Encryption setting for this data source” to “Encrypted”

it helped many users facing the similar issues

[k_foxy]

What I noticed in Vnet gataway logs is that credentials are missing, even when I add them it will not connect me, looks like "Take Over" removes credentials to MySQL. How to overcome this ?

[k_foxy · Accepted solution]

When I use option Encrypted it will not connect to the source.  The source is not allowing SSL connections.