Connecting SQL server in snap logic

[sathishmadavali]

hi,
when i am connecting SQL account in snap logic, i am getting this error. how to connect SQL account in snap logic.

thanks

[sathishmadavali]

any one can help me regarding the error?

[smudassir]

Hi @sathishmadavali , is your db instance behind a firewall? Using any db client tool (db viewer, etc), are you able to connect to that db instance from the node where your jcc is running?

[sathishmadavali]

hi, the sql db is in my local machine, it is behind firewall.

[smudassir]

probably that could be the reason. Can you whitelist the IP of the plex machine in your local firewall to allow the traffic?