The cloud sql MSSQL which i created , i am able to connect it from sql server management studio on my laptop (Which is not on google network) however to my surprise when i connecting it from dataproc or dataproc serverless by running same pyspark job which is running on my local and connecting same SQL sever is not able to connect sqlserver and giving the error .
Based on google search , I have enabled the firewall rules for ingress and egress on port 1433 to allow all 0.0.0.0/0 .
Could anyone please help what is this issue .
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host ***********, port 1433 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."
LinkedIn
Twitter
