Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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:
To learn more detail solution ,refer:
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
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:
To learn more detail solution ,refer:
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
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
User | Count |
---|---|
45 | |
26 | |
21 | |
18 | |
18 |
User | Count |
---|---|
52 | |
45 | |
24 | |
24 | |
21 |