Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Getting error while creating a data sources to Power BI gateway

Hi, while creating a new data sources to power BI gateway we are getting the below error could u please help us. 

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.

Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net/
Status code: 400
Error Code: DMTS_PublishDatasourceToClusterErrorCode
Time: Mon Feb 07 2022 15:11:46 GMT+0200 (Eastern European Standard Time)
Service version: 13.0.17618.45
Client version: 2201.5.09798-train
MSBI Gateway: SQL Server connection failed
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
DM_ErrorDetailNameCode_UnderlyingHResult: -2146232060
DM_ErrorDetailNameCode_UnderlyingNativeErrorCode: 53
MSBI Gateway_p2: SQL Server connection failed
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
DM_ErrorDetailNameCode_UnderlyingHResult: -2146232060
DM_ErrorDetailNameCode_UnderlyingNativeErrorCode: 53

2 Replies