DF-MSSQL-InvalidFirewallSetting for azure SQL database

Ankit Dubey 1 Reputation point
2022-08-16T18:22:55.927+00:00

Operation on target Transform_Form_PropertyData failed: {"StatusCode":"DF-MSSQL-InvalidFirewallSetting","Message":"Job failed due to reason: The TCP/IP connection to the host has failed. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.","Details":"shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host xxxxx-a.worker.database.windows.net (redirected from xxxx.database.windows.net), port 11013 has failed. Error: \"connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.\".\n\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:234)\n\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:285)\n\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2466)\n\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:672)\n\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnec"}

Azure SQL Database
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Alberto Morillo 32,796 Reputation points MVP
    2022-08-16T19:33:14.25+00:00

    Please check the firewall setting for your SQL database or Synapse resoources, and allow Azure services and resources to access them. You can read here more detailed information on how to configure firewall settings.

    Traffic over port 1433 must be allowed as it is needed to access a SQL database.

    The IP address of any self-hosted integration runtime or your hosted computer involved should be whitelisted on the Azure SQL/Synapse firewall.

    231725-image.png


  2. Oury Ba-MSFT 16,076 Reputation points Microsoft Employee
    2022-08-16T23:28:28.737+00:00

    Hi @Ankit Dubey Thank you for posting your question on Microsoft Q&A and for using Azure services.
    In addition to @Alberto Morillo 's answer.

    Please make sure your connection string is correct and that it's accessible. Check you can access your database locally and then push the connection string to your app service.
    Tutorial: Deploy an ASP.NET Core and Azure SQL Database app to Azure App Service

    Regards,
    Oury