Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

0
tzhang

A network-related or instance-specific error occurred while establishing a connection to SQL Server.

Submitted by on ‎11-18-2022 10:06 AM

hi,

We had error in power bi service gateway. 

 

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)

 

ActivityId: fcf41a0d-1df9-45e3-967b-f85727530c9a RequestId: 89f9bdb3-3a1e-4a63-b509-2c4aef41d415 Cluster URI: https://api.powerbi.com Status code: 400 Time: Fri Nov 18 2022 12:59:38 GMT-0500 (Eastern Standard Time)

 

I looked in logs but there is nothing in log table on this requestid. 

 

Please help! 

Status: Delivered
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎11-20-2022 09:59 PM

Hi @tzhang 

This error usually means that the client can't find the SQL Server instance. This normally happens when at least one of the following problems exist:

  • The name of the computer hosting the SQL Server
  • Instance does not resolve the the correct IP
  • The TCP port number is not specified correctly

Checklist:

  1. SQL Server are up are runing
  2. check the correct instance name
  3. add in exception in firewall
  4. check if anti virus is using it
  5. check the sql browser services

Please refer the following Microsoft document and cases that could also help you:

  1. https://community.powerbi.com/t5/Desktop/SQL-Connection-error-Named-Pipes/td-p/29203
  2. https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-th...
  3. https://support.microsoft.com/en-us/help/4009936/solving-connectivity-errors-to-sql-server

 

Best Regards,
Community Support Team _ Ailsa Tao

tzhang
Regular Visitor
‎11-21-2022 09:24 AM

Hi,

 

We tried everything, still no luck. 

 

To test further, we removed the DB restriction on port 1433 and the gateway connection worked.

 

the gateway and database on the same VM.

 

Is there any way we can specific DB port so it allows Power BI sevice gateway to access to our database? 

 

Regards,

Tony

Idea Statuses