Error while adding SQL data source using on-premises gateway:

[camelenchanter]

Hi,

I am trying to add an SQL data source using on-premises data gateway and receive the following error message:

Unable to connect: We encountered an error while trying to connect to XXX.XXX.XXX.XXX:11111. 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."Hide details
Activity ID:    cafce48b-c9f2-4315-90a5-5f7e38e98646
Request ID:    30f84723-6c4d-4151-cd38-b30ca2006783
Cluster URI:    https://wabi-west-europe-redirect.analysis.windows.net
Status code:    400
Error Code:    DMTS_PublishDatasourceToClusterErrorCode
Time:    Tue Apr 17 2018 16:41:46 GMT+0300 (FLE Daylight Time)
Version:    13.0.5027.161
POWERBI:    Cannot connect to the server.
Underlying error code:    -2146232060
Underlying error message:    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)
DM_ErrorDetailNameCode_UnderlyingHResult:    -2146232060
DM_ErrorDetailNameCode_UnderlyingNativeErrorCode:    87

I seem to be able to access the server from Power BI Desktop on the server where gateway is installed (or any other machine). Gateway is installed on Win Server 2012

Any help is much appreciated.

[Shukshuk]

Hello,

I am facing the same problem with enterprise gateway. 

Did you able to solve this issue ? 

Thanks a lot 

[v-piga-msft]

Hi @camelenchanter,

Underlying error message:    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)

From the error message, please check if you have typed in the right Database name and Server name .

Best Regards,

Cherry