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 ...
Need Help
Tips and Tricks
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.