cancel
Showing results for 
Search instead for 
Did you mean: 

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

philliperamos
Contributor

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.
image
(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!!!

1 ACCEPTED SOLUTION

philliperamos
Contributor

My colleague helped, and we removed the port number from the account configuration, and it worked.

View solution in original post

5 REPLIES 5

dmiller
Former Employee

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


Diane Miller

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

Could it be the SERVERNAME\INSTANCENAME format as hostname?

dmiller
Former Employee

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.


Diane Miller

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