AnsweredAssumed Answered

FileMaker Cloud and ODBC

Question asked by jonmyrah on Nov 10, 2016
Latest reply on Nov 12, 2016 by AndresLP

Looking for help adding an ODBC Source to my FileMaker Cloud server, but there is little to no info that I can find in the FM Cloud documentation. Has anyone out there been successful with this so far? When I "Test Source Connection" from the FM Cloud console I get the error "Connection failed Timeout: Could not SQLConnect".

 

Trying to connect to a MS SQL server. The network hosting the SQL server has been setup to allow a connection from the FM Cloud public IP on port 1433. Is there anything else that needs to be configured on the AWS side besides the basic info in the FM Cloud admin console?

 

From the AWS console I noticed that the default configuration for FM Cloud only opened up ports 80, 443, and 5003 in the security group that it created. I added 1433 (limited to the SQL source IP) and 2399 for FM ODBC connections, but I'm not sure if that was required.

 

Thanks!

Outcomes