Getting error while creating a data sources to Power BI gateway

[Anonymous]

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

[v-luwang-msft · Accepted solution]

Hi @Anonymous ，

This error means that the client can't find the SQL Server instance. This can happen when at least one of the following problems exists:

• The name of the computer hosting the SQL Server instance doesn't resolve the correct IP
• The TCP port number isn't specified correctly

To learn more detail solution ,refer:

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-the-sql-server-database-engine?view=sql-server-ver15 

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[arvindsingh802]

It seems Gateway server is not able to access the SQL server
refer Resolving could not open a connection to SQL Server errors (mssqltips.com) for resolvution