ProxySQL Error: Access Denied

Discussion of issues, suggestions and bugs of Devart SSIS Data Flow Components, our product line for building SSIS-based ETL solutions, performing data access to popular cloud applications and databases.
Post Reply
themochael
Posts: 2
Joined: Thu 28 Jun 2018 14:45

ProxySQL Error: Access Denied

Post by themochael » Thu 28 Jun 2018 14:49

I am using MySQL SSIS components. When I try to run a debug in Visual Studio, I get this error:
Error: 0x0 at UPDATE INSERT PATIENTS, Devart MySql Destination: An error occurred with the following error message: "ProxySQL Error: Access denied for user 'user@server' (using password: NO)"
Error: 0xC0047062 at UPDATE INSERT , Devart MySql Destination [2]: System.Exception: An error occurred with the following error message: "ProxySQL Error: Access denied for user 'user@server' (using password: NO)"
at Devart.SSIS.Common.PipelineComponentBase.AcquireConnections(Object transaction)

I am using the password and the check box "save password" is checked

themochael
Posts: 2
Joined: Thu 28 Jun 2018 14:45

Re: ProxySQL Error: Access Denied

Post by themochael » Thu 28 Jun 2018 20:33

In case anyone ever has this issue with Visual Studio. If you set your package protection level to EncryptAllWithUserKey or anything else, it will work. If you tell it to not save any sensitive data, it will error.

Post Reply