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 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!!!

  • philliperamos's avatar
    philliperamos
    6 years ago

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

5 Replies

  • philliperamos's avatar
    philliperamos
    Contributor
    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?