Forum Discussion
Troubleshooting Gateway
Hi EVEAdmin ,
No need to create new cluster for them, you can put them under same cluster.
After addind them to data source setting in gateway, could you plz make sure the it prompts "Connection succesfully"?
v-diye-msft thank you
That is what I did. I first put each gateway under the same cluster.
After I add the datasource details, it does say Connection Successful along with a message that say it could not connect to the datasource. The error details refer to something similar to the following
| Cluster URI: | WABI-NORTH-EUROPE-redirect.analysis.windows.net |
| Activity ID: | 4c600672-dd5f-429c-8eb0-5bb5e1f48f43 |
| Request ID: | 8d86151f-5f22-4f09-9096-01ba68477466 |
| Time: | 2018-07-28 09:31:21Z |
Hi EVEAdmin ,
There's only one gateway works in one time (unless On-premise and Personal ), did you put all the source info under same gateway? rather than different gateways?
v-diye-msft thank you again.
I just installed again the gateway, not in personal mode, on SERVER03. The gateway has been added to the Cluster created with the primary account, installed on SERVER02.
I also added the datasources and mapped them again the gateway.Everything looks fine.
HOwever, when I test the datasource connection, I get the error below, where basically the Server03 data settings cannot establish connection to the Server02:
Finally, if I try and refresh the dataset, I get the error below.
Error 40 is what SQL will throw when you cannot login.
If I install each gateway in its own cluster, it all works. BUt, I cannot build a report that grabs data from each SQL of those SQL servers.
I'd be very happy to find out what I am doing wrong.