title: JDBC connect string for SQL Server cluster
body: <p>I need to setup a JDBC connection string to SQL Server.
  This question is similar to the the <a href="https://stackoverflow.com/questions/751634/connection-string-to-a-sql-server-cluster">C# ADO.Net connection question</a>. This one is specific to JDBC connection strings. </p>
  
  <p>The usual format for the JDBC string is "jdbc:sqlserver://{host}:{port}".
  Now, for a SQL server cluster I have a cluster name vvv\iii ({virtual server}{instance name}). </p>
  
  <p>There's no problem setting up an ODBC connection through the "New Data Source to SQL Server" wizard when using the vvv\iii string as the server name. However it seems the JDBC connection string requires a specific host and port. </p>
  
  <p>Is there a way to make a JDBC connect string to a SQL Server cluster?</p>