Forum Discussion

emartinezh's avatar
emartinezh
Icon for Helper I rankHelper I
2 years ago

AWS vm doker problem connecting to SQL analytics fabric endpoint.

Hello good morning and thank you all for your effort helping people :).

We're trying to connect a docker c# application with nugget packet using sqldataclient, that reads from a fabric sql endpoint throught service principal deployed on the Microsoft Azure Entra ID, working fine in local but when we execute this connection string on a docker AWS virtual machine it's giving problems on connection.

Do you know if theres a restriction that could be affecting to the connection on this service? or do we we have to connect this docker container on other way?

By the way this docker container has not restriction on his firewall AWS NSG.

The message error we're experiencing is the following.

[One or more errors occurred. (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

Thank you so much in advance.

Best Regards.

Eduardo.

data warehouse

5 Replies

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    2 years ago

    Hi emartinezh 

     

    Thanks for using Microsoft Fabric Community.

    In order to understand your scenario, could you please share some more details about your connection. This will help me to understand the query and guide in better way. If feasible, sharing screenshots would be highly beneficial for visualization purposes.

     

    Thanks.

    • emartinezh's avatar
      emartinezh
      Icon for Helper I rankHelper I
      2 years ago

      Hello v-cboorla-msft and thank for your reply :).

      We've deployed a Fabric Azure Sql Analytics Endpoint in our Fabric environment and a Service Principal with read permissions that can connect without problems to this Endpoint to read data, all well until this.

      We have an application that runs c# on docker 24.0.5 and this is using the same connection string that in local and in local works and in docker does not run.

      The error is giving is: "[One or more errors occurred. (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"

      This looks like there's something between the docker instace and the endpoint that its blocking, we've done tests deleting the rules on the firewall to allow inbound at outbound traffic from the E2C instance but still not working.

      As I understand it, the SQL endpoints do not have any type of firewall filtering activated that could be preventing traffic?Because this is working in our local environment...

      Thank you so much in advance and i hope i have explained myself well.

      Best Regards,

      Eduardo.