Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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_PublishDatasourceToClusterErrorCode
There 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's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity 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.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi v-janeyg-msft 

       

      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's avatar
        v-janeyg-msft
        Icon for Community Support rankCommunity 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's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity 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.