title: Using a SRV DNS entry to connect to SQL Server in .NET
body: <p>We have a cluster SQL Server and we use a SRV DNS entry to locate the service (i.e <code>sql.mycompany.com</code>).</p>
  
  <pre><code>MyCompany.com_tcp_http Service Location (SRV) [0][0][1433]sql.Mycompany.com
  </code></pre>
  
  <p>Now, how I can use the .NET SQLConnection to use this dns name (instead of the server name/IP)? Any ideas? <br />Should I use <code>System.Net.Dns</code> to translate it first?</p>