Reply
Highlighted
Established Member
Posts: 156
Registered: ‎01-28-2016
Accepted Solution

Gateway Error - Cannot be added to gateway

Hi there,

 

I've configured an enterprise gateway that connects to a SQL Server and refreshed fine. I recently added a new data source using a Dataflow that connects to the same SQL Server and is using the same enterprise gateway, and am now getting the following error:

 

Capture2.PNG

 

Has anyone else came across this error?

 

Thanks.


Accepted Solutions
Established Member
Posts: 156
Registered: ‎01-28-2016

Re: Gateway Error - Cannot be added to gateway

I took my reports off the service, rebuilt the dataflow and uploaded them again. It seemed to have fixed the issue, still not sure what caused the failure but the classic on/off approach has saved the day again.

View solution in original post


All Replies
Super User
Posts: 1,790
Registered: ‎02-28-2017

Re: Gateway Error - Cannot be added to gateway

[ Edited ]

Is this new source on the same SQL Server but within a different database?  If so, you'll need to configure another gateway connection for this database.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


Established Member
Posts: 156
Registered: ‎01-28-2016

Re: Gateway Error - Cannot be added to gateway

Hi @Ross73312, appreciate the reply.

 

Both of the sources are within the same database and I have a Pro account.

Established Member
Posts: 156
Registered: ‎01-28-2016

Re: Gateway Error - Cannot be added to gateway

Could it have anything to do with permissions and privacy levels? Both data sources have a privacy level of organisational and the gateway also has organisational as its privacy level.

Super User
Posts: 1,790
Registered: ‎02-28-2017

Re: Gateway Error - Cannot be added to gateway

Based on that, everything should be ok.  There must be something else at play.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


Established Member
Posts: 156
Registered: ‎01-28-2016

Re: Gateway Error - Cannot be added to gateway

I took my reports off the service, rebuilt the dataflow and uploaded them again. It seemed to have fixed the issue, still not sure what caused the failure but the classic on/off approach has saved the day again.