We have accomplished a data communication with a C# winforms project between a SQL Server and Remote MySQL (WEB) database (Unix platform). All the data is being updated with a custom made software.
What we want is that this communication must be encrypted (secure) when we update, insert a row or when a sql select statement is being made.
IS there a way that Visual Studio can secure this communication line?
All the data right now is open.
Yes, MySQL supports secure connections using SSL, and MySQL Connector/Net supports this. You need SslMode=Required; in the connection string and you need a certificate.
Lots of details on the MySQL site:
It is not clear regarding endpoints. But I guess you need at least to communicate with SQL Server using SSL from VS. You can read about that here. Alternatively you can make secured network connection itself (using VPN, IPSec).
My SQL also supports TLS as well. So you need to read documentation.
UPDATE: I cannot help you with Plesk (it is different topic). But I guess SQL Server when installed should use some SSL certificate. Unfortunately I think it will be untrusted... So to use that certificate and skip certificate validation you can add this to your connection string:
Encrypt=true;TrustServerCertificate=true;
But keep in mind that such connection can be impacted by Man-in-The-Middle attack. So it is better to setup server in right way.
