title: Cannot connect to on-prem SQL Server with Google Cloud Data Fusion
body: <p>I am trying to test a connection using Cloud Data Fusion to connect to an on-prem SQL Server. Our GCP Project does not use the default network but rather a custom VPC.</p>
  
  <p>It's important to note that security is very important as this database contains healthcare data.</p>
  
  <p>We currently have App Engine Flex code that uses pymssql to query the database on this SQL Server through the VPC, and want to test using Data Fusion.</p>
  
  <p>I have copied and added the generated data fusion service account to IAM with role Cloud Data Fusion API Service Agent.</p>
  
  <p>I have configured in Data Fusion </p>
  
  <pre><code>system.profile.properties.network = &lt;VPC name&gt; 
  </code></pre>
  
  <p>I have verified that the username and password for authentication to SQL Server are valid for the database.</p>
  
  <p>THE VPC network allows port 22 and 1433.</p>
  
  <p>At this point I am just trying to get a successful connection to query a table in the database.</p>
  
  <p>Here is the error message I get:</p>
  
  <blockquote>
    <p>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.</p>
  </blockquote>
  
  <p>Thoughts?</p>