Connection error with CDS

[Anonymous]

Hi all,

I am trying to connect to CDC via Power BI. I already made sure that the endpoint is activated:

And my database version (9.1.0000.24054) should be high enough as well.

When i now connect to the Environment URL, i get an error message saying i cannot connect due to "network or entity specific errors when connecting to SQL Server. Server was not found or could not be accessed. (provider: Named Pipes Provider, error: 40 - Connection to SQL Server could not be established)"

Why do i get this error? Could it be due to not enough permissons?

Regards

Dennis

[v-yingjl]

Hi @Anonymous ,

Based on the error message, error 40 means you cannot establish connection to SQL server, you can check below:

1. lease make sure your database engine is configured to accept remote connections.
2.  Please make sure that you create an exception on the firewall for the SQL Server instance and port you are using.
3.  Please check if your SQL server services is up and running properly.
4. Please make sure that you enable TCP/IP in SQL Server Configuration

This article could be a reference for you:

Resolving could not open a connection to SQL Server errors 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.