Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

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

View solution in original post

2 REPLIES 2
v-luwang-msft
Community Support
Community Support

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
Super User
Super User

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


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors