Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Report Server no conecta a MySQL v8

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 pro...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

  • vcarazo's avatar
    vcarazo
    Frequent Visitor
    2 years ago

    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.