Gateway Connection Error

[scottm704]

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_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[],"exceptionCulprit":1}}} Table: 1PD.

The Windows account can successfully query the database tables being used in the report so I am unsure of where to go from here. 

[scottm704 · Accepted solution]

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

[GilbertQ]

From your error it appears that the user account cannot access the table 1PD?

[scottm704]

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]

Could you verify that the Gateway server can access the SQL Server?