Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

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 s...
v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
4 years ago

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:

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-could-not-open-a-connec 

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

 

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


Best Regards

Lucien