title: Connecting to a 2014 SQLEXPRESS database on an externally hosted computer through TCP/IP
body: <p>I am working on a system whereby I can update a small database from several locations. I wish to host the database on my home computer and allow connections to be made to the database from two other locations through tcp/ip.</p>
  
  <p>I have done the following thus far:</p>
  
  <ol>
  <li>Enabled TCP/IP for SQLEXPRESS</li>
  <li>Allowed port 1433 tcp on my firewall</li>
  <li>Allowed port 1434 udp on my firewall</li>
  <li>Enabled SQLEXPRESS server to allow remote connections</li>
  </ol>
  
  <p>I was hoping to be able to connect to the database by opening sql management studio on the other pcs and using the following format [ExternalIP]\SQLEXPRESS but as of yet I have been unable to do so. I have looked at what my external IP might be and i am getting two different values:</p>
  
  <p>86.XX.X.XXX
  66.XXX.XX.XX</p>
  
  <p>Should I be using either of these values with this format to connect from the other sql management studios when everything has been correctly configured? Are there any steps that I am missing?</p>