title: How to Enable TCP/IP for mssql instance in ubuntu 16.04?
body: <p>I'm not able to connect SQL Server hosted in Ubuntu 16.04 using my program, I believe its because the TCP/IP is disabled for the instance I try to connect (Protocols for SQLEXPRESS under SQL Server network configuration).</p>
  
  <p>How I'm sure because I tried to connect my program to SQL Server that hosted in Windows and it able to connect. </p>
  
  <p>Example my instance name is SQLEXPRESS, so I'm trying to connect through SSMS by using IP Adress\SQLEXPRESS and it fails. But I am able to connect to the SQL if I use IP address only as the server name. </p>
  
  <p>I tried to search about sqlcmd for enable the tcp/ip but all of them just show the guide to change the ports. </p>
  
  <p>So, how can I enable tcp/ip connection for ip\SQLEXPRESS instance in Ubuntu 16.04? </p>
  
  <p>picture below just an example on enabling tcp/ip for the sql instance in windows</p>
  
  <p><img src="https://i.stack.imgur.com/tXrf3.png" alt="The setting in windows sql server configuration"></p>