Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Connection error with CDS

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

Need Help
Tips and Tricks

1 Reply

  • v-yingjl's avatar
    v-yingjl
    Community Support
    5 years ago

    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.