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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Syndicate_Admin
Administrator
Administrator

SQL Server connection failed

Someone knows how to solve this problem, it is not a problem or connection to the server or password, but power bi does not let you connect
Unable to update the credentials for this data source. SQL Server connection failed

Details:
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)
Keep this information handy if you decide to create a support ticket.
Activity ID: d7c71978-4c01-4906-aa3d-07cb55faf3be
RequestId: 078176b5-e2fe-4a72-ba36-421826b8c16e
Cluster URI
Status Code: 400 Time: Fri Jul 08 2022 09:32:58 GMT-0600 (Central Standard Time)
2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

that such good morning, if you notice that I had already reviewed this, I have ticket already with Microsoft support and show them the whole process and they realized that if it does not let you connect even though it is not firewall, proxy, port, password. I think it's already a power bi problem as such.

v-luwang-msft
Community Support
Community Support

Hi @Syndicate_Admin ,

Pls test the below steps:

  1. Go to control panel.
  2. search for services.
  3. Open Local services window from your search results
  4. Restart your MSSQLSERVER service.

Screenshot of the steps:

vluwangmsft_1-1657526328105.png

Also could test the below:

1. Please check if the outbound traffic over port 1433 port is allowed on the machine which has desktop runs.

2. Please add firewall rules to specify which IP address ranges from the Internet are allowed. See: Azure SQL Database server-level and database-level firewall rules.

3. Please enable Telnet Client feature then run telnet command in cmd. See: Windows 7: Enabling Telnet Client.

 

 

Similar error refer:

https://stackoverflow.com/questions/9945409/how-do-i-fix-the-error-named-pipes-provider-error-40-cou... 

https://community.powerbi.com/t5/Power-Query/SQL-Connection-Named-Pipes-Provider-error-40/td-p/19429... 

 

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


Best Regards

Lucien

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.