0

I am trying to configure the connection manager in SSIS using .Net Providers\MySQL Data Provider to connect to a MySQL database on a remote server. I am basically following this tutorial

https://smallbusiness.chron.com/connect-mysql-ssis-60851.html

I typed the Database and server name and the UserId who is a database user as well as the corresponding password. But when I test connect, it gives the following error enter image description here I am certain that the input information is correct. What could be the possible reason that I am getting this error?

By the way, the server login user and the database user are not the same. (But do we even need the server login user at all?)

Ning
  • 499
  • 1
  • 4
  • 16
  • I believe your issue is that root-level remote access is not enabled. Check out the first answer to this question to see if it solves your problem: https://stackoverflow.com/questions/14779104/how-to-allow-remote-connection-to-mysql – digital.aaron Apr 29 '20 at 20:10
  • Thanks, that answer solved the problem. I needed to create a user for my specific 'desired_ip' and grant the permission – Ning Apr 29 '20 at 23:50

0 Answers0