Forum Discussion

philliperamos's avatar
philliperamos
Contributor
6 years ago
Solved

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

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...
  • philliperamos's avatar
    philliperamos
    6 years ago

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

dmiller's avatar
dmiller
Former Employee
6 years ago

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

  • philliperamos's avatar
    philliperamos
    Contributor
    6 years ago

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

    Could it be the SERVERNAME\INSTANCENAME format as hostname?