title: VB.NET connection string for client-server application
body: <p><strong>Case :</strong></p>
  
  <p>I'm creating a desktop application with VB.NET (Windows Forms), and using SQL Server 2008 Express for its database.</p>
  
  <p><strong>Problem :</strong> </p>
  
  <p>I want to create a client-server application, it means I just need 1 database on the server.</p>
  
  <p>I have a computer and a laptop. I set my laptop's IP to <code>192.168.1.1</code> and my computer's IP to <code>192.168.1.2</code>.</p>
  
  <p>Now I place the database on my computer, the database name is <code>db_transportasi</code>.</p>
  
  <p>Problem is, how to connect my computer's database from my laptop?</p>
  
  <p><strong>Specification :</strong></p>
  
  <p>I'm using this string below for my connection :</p>
  
  <pre><code>Data Source=ARVID-THEODORUS\SQLEXPRESS;Initial Catalog=DB_TRANSPORTASI;Integrated Security=True
  </code></pre>
  
  <p>I already setup my SQL Configuration Manager, enabled the TCP/IP, switch to the <code>IP Addresses</code> tab and set the IPAII Port Properties to 2301</p>
  
  <p>I turned off my firewall so I don't have to set any exception.</p>
  
  <p>Here is the SQL Server SS :</p>
  
  <p><img src="https://i.stack.imgur.com/Tnp2v.jpg" alt="SQL Server First Connect"></p>
  
  <p><strong>Question :</strong></p>
  
  <ol>
  <li><p>How to connect to my computer's database from my laptop?</p></li>
  <li><p>Could you show me the example for my laptop VB.NET Connection String?</p></li>
  </ol>
  
  <p>Thanks before.</p>