SQL Server connection failed

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

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.

Hello

I have an error when making the connection to the SQL Server DB from fabric Gen 2 data stream, the credentials, link port and server name are correct, but it generates the error always.

Invalid credentials. (Session ID: 80a900a8-ddf0-4a00-bd47-93bfd15f8c1f, Region: europe)

we have a PWER BI Pro license

and from Fabric a trial license