topic Report Server no conecta a MySQL v8 in Report Server

Report Server no conecta a MySQL v8

Syndicate_Admin — Thu, 13 Jun 2024 11:11:43 GMT

Hello

when we connect to a MySQL v8 in SaaS through MySQL connector/NET Power BI desktop allows us to indicate that the communication will be encrypted and Power BI Desktop connects without problem to MySQL.

The issue appears when you publish the dashboard to Power BI Report Server. When configuring the dashborad connection from the Power BI Report Server portal by entering the username and password, the following error appears when checking the connection:

MySQL: Authentication to host 'XXXXXXXXXX for user 'OXXXXXX' using method 'mysql_native_password' failed with message: Connections using insecure transport are prohibited while --require_secure_transport=ON.

How can we tell or force you to encrypt the connection?

Best regards

Victor

Re: Report Server no conecta a MySQL v8

Anonymous — Fri, 14 Jun 2024 01:32:59 GMT

Hi Syndicate_Admin ,

Use both:

config mysql system configuration (require_secure_transport=off)
Client connection to mysql server using SSL/TLS protocol configuration

Properly configure the MySQL server to support SSL connections. This includes having a valid server certificate

Below is the link will help you:

dev.mysql.com

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Report Server no conecta a MySQL v8

vcarazo — Fri, 14 Jun 2024 06:37:47 GMT

Hello

we cannot modify require_secure_transport on the server since we use MySQL in a cloud and it is a managed service. The only solution is to be able to force the Report Server to initiate an encrypted connection.

Regarding what is indicated in https://dev.mysql.com/doc/refman/8.0/en/using-encrypted-connections.html I do not see a way to indicate any parameter in the report server connection form.

Best regards.