SQL Server connection failed

[Syndicate_Admin]

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)

[Syndicate_Admin]

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

[Syndicate_Admin]

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]

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