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]

i am not understanding what you are saying. fire wall is alreday on in my local machine

[smudassir]

where is the jcc running? Lets say its running on x machine. So, in your local machine, are you allowing the traffic from x machine?

[jcornelius]

you should not need server name and it listed in front of user name
enter the data the same way you would on SSMS

[sathishmadavali]

hi,
After adding the firewall, again same error will happen?

[dmiller]

@sathishmadavali if you are trying to do this in the SnapLogic trial, we currently do not support connection to on-premise databases. Any database installed locally and not available via the intranet would require a Groundplex, which is not available as a default option in the trial.