SQL Server Account - Connecting using SSMS, but not with SnapLogic

[philliperamos]

Hello community,

I’m trying to setup an SQL Server Account in Snaplogic to access a database on an SQL Server.
I am able to get access to the server using SSMS, but not in Snaplogic.

(last line of the error is “Resolution: Address the reported issue”)

I am using the same account for SSMS in Snaplogic.

Any assistance with this would be appreciated. Thanks!!!

[dmiller]

Is the SQL Server on-premises or in the cloud?
If on-premises, are you using a Groundplex?

[philliperamos]

@dmiller it is on-premises, and yup, using the Groundplex.

Could it be the SERVERNAME\INSTANCENAME format as hostname?

[dmiller]

And your IP address whitelist is up to date? There was an update made over the summer; see Snaplex IP Address Whitelist Update in the documentation.

[philliperamos]

Ok, thanks.
I’ll look into the IP whitelist.