title: Cannot connect with SSMS to SQL Server on Docker
body: <p>I have followed the official Microsoft <a href="https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-ver15&amp;pivots=cs1-powershell" rel="noreferrer">documentation</a> and I have installed SQL Server Docker image </p>
  
  <p>As result I have a SQL Server image running on Docker at the IP address 172.17.0.2</p>
  
  <p><a href="https://i.stack.imgur.com/lpjq2.png" rel="noreferrer"><img src="https://i.stack.imgur.com/lpjq2.png" alt="enter image description here"></a></p>
  
  <p>I also can easily connect to it using sqlcmd with my dummy password</p>
  
  <p><a href="https://i.stack.imgur.com/wx2VC.png" rel="noreferrer"><img src="https://i.stack.imgur.com/wx2VC.png" alt="enter image description here"></a></p>
  
  <p>The problem is that I cannot connect to it through SSMS:</p>
  
  <pre><code>Login failed for user 'sa'. (Microsoft SQL Server, Error: 18456)
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/8yp8X.png" rel="noreferrer"><img src="https://i.stack.imgur.com/8yp8X.png" alt="enter image description here"></a></p>
  
  <p>Of course I read other StackOverflow <a href="https://stackoverflow.com/questions/47984603/using-sql-server-management-studio-to-remote-connect-to-docker-container/55905653">posts</a> before posting this question and I have tried multiple logins: </p>
  
  <ul>
  <li>localhost,1433</li>
  <li>localhost:1433</li>
  <li>172.17.0.2,1433</li>
  <li>etc...</li>
  </ul>
  
  <p>How can I connect if localhost doesn't work as well as the IP address of the docker image? </p>