title: Connect to SQL SERVER from google sheets
body: <p>I want to connect to a SQL SERVER on my machine through google sheets. I have port forwarded, set up appropriate firewalls and started the server browser and all of these are working. Here is the jdbc connection string I am using</p>
  
  <pre><code>  var conn = Jdbc.getConnection("jdbc:sqlserver://x.x.x.x:x;databaseName=anviz;user=sa;password=sa");
    if(conn.isClosed()==false){Logger.log("closed");};
  </code></pre>
  
  <p>When I run this, I get
  <code>We're sorry, a server error occurred. Please wait a bit and try again. (line x, file "Code")</code> 
  This means at least to me that the connection string is not set up properly. Does anyone know how to set it up so that it can connect to <strong>SQL SERVER 2012</strong>?</p>