Forum Discussion

scottm704's avatar
scottm704
Helper I
6 years ago
Solved

Gateway Connection Error

I am trying to use a Windows login with the Windows authentication method as the credentials for an enterprise gateway connection and keep getting the following error: {"error":{"code":"DM_GWPipelin...
Need Help
  • scottm704's avatar
    scottm704
    5 years ago

    The issue turned out to be the firewall. The gateway server and the database servers are on different subnets in our network schema and we needed to allow traffic on the following ports between the servers:

    TCP 1521

    TCP 443

    TCP 5671-5672

    TCP 9350-9354

scottm704's avatar
scottm704
Helper I
6 years ago

I verified the user account can run the same query that the workbook is using in the database through SSMS. That's what is making it difficult to troubleshoot and confusing me about the error message, the database permissions are set up correctly. 1PD is the database name, the report is built off of a view in the 1PD database.

GilbertQ's avatar
GilbertQ
Super User
6 years ago
Could you verify that the Gateway server can access the SQL Server?