Forum Discussion
Unable to add datasource to Gateway Cluster
Hi,
I am trying to add an SQLServer database to my gateway cluster as new data source. But I am getting an error (details given below)
Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Status code: 400
Error Code: DMTS_PublishDatasourceToClusterErrorCodeThere was an error in the data gateway.
Underlying error message: Error occurred while decoding OAEP padding.
DM_ErrorDetailNameCode_UnderlyingHResult: -2146233296
In the same server instance, there are other databases and earlier I have added them without any issue. Now when I tried to add a new database as a new data source, I am getting the error mentioned above.
I have tested the gateway and all the data sources in that and everything is working fine. One additional information is that I tried to test the issue whether it is related to the specific database I am trying to connect or not by trying to add a database that is already configured as a data source and is working fine, but it turns out that, I am not able to add any database newly - even the ones that are already working fine.
I searched the internet and could not find any helpful links to solve this. The server is online, the gateway is working fine, I have administrator access to the server, the databases, the on-premise gateway that is running on the server, and the credentials are correct, server IP address, port numbers are correct. Not able even replicate an already working data source, the reports that are relying on the data sources that are already configured are refreshing automatically without any issue.
Please help
12 Replies
- v-janeyg-msft
Community Support
Hi, Anonymous
It’s my pleasure to answer for you.
You need to check if your gateway is the latest version.
Can other types other than database type data sources be added to the gateway?
Are the gateway and data source installed on the same machine?
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AnonymousNot applicable
My gateway is the latest version.
It is installed on the server that has SQL server is installed.
I don't have any other data sources that connect through this gateway other than the SQL Server database.
- v-janeyg-msft
Community Support
Hi, Anonymous
Can you try to connect to other types of data sources?To troubleshoot the problem of the data source or the gateway.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- v-janeyg-msft
Community Support
Hi, Anonymous
Sign in the gateway account again and make sure the account is the user you used for registration of on-premise gateway to PowerBI and O365 portal.
I'm sorry for that,I am also trying my best to find some possible reasons, there's no clear reason for this error, it needs to be investigated.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.