https://community.databricks.com/t5/data-engineering/need-help-to-connect-to-local-db-from-data-bricks/m-p/9854#M5137 <P>Hi, Could you please verify the network connectivity from Databricks to the SQL server? Please make sure SQL:port is allowed in your firewall rules or security groups. </P> Wed, 08 Feb 2023 07:05:15 GMT Debayan 2023-02-08T07:05:15Z https://community.databricks.com/t5/data-engineering/need-help-to-connect-to-local-db-from-data-bricks/m-p/9853#M5136 <P>jdbcHostname="478"</P><P>jdbcPort=1433</P><P>jdbcDatabase="Onprem_AzureDB"</P><P>jdbcUsername="upendra"</P><P>jdbcPassword="upendrakumar"</P><P>jdbcDriver="com.microsoft.sqlserver.jdbc.SQLServerDriver"</P><P>jdbcUrl=f"jdbc:sqlserver://{jdbcHostname}:{jdbcPort};databaseName={jdbcDatabase};user={jdbcUsername};password={jdbcPassword}"</P><P></P><P>test1=spark.read.format("jdbc").option("url",jdbcUrl).option("dbtable","onprem_table1").load()</P><P>display(test1)</P><P></P><P>Error:</P><P>com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host 478, port 1433 has failed. Error: "478. 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.".</P> Tue, 07 Feb 2023 14:44:54 GMT https://community.databricks.com/t5/data-engineering/need-help-to-connect-to-local-db-from-data-bricks/m-p/9853#M5136 Skesaram 2023-02-07T14:44:54Z https://community.databricks.com/t5/data-engineering/need-help-to-connect-to-local-db-from-data-bricks/m-p/9854#M5137 <P>Hi, Could you please verify the network connectivity from Databricks to the SQL server? Please make sure SQL:port is allowed in your firewall rules or security groups. </P> Wed, 08 Feb 2023 07:05:15 GMT https://community.databricks.com/t5/data-engineering/need-help-to-connect-to-local-db-from-data-bricks/m-p/9854#M5137 Debayan 2023-02-08T07:05:15Z