title: sql server 2014 "localhost\instancename" is not connecting via sql authentication but when connected as "localhost" its working
body: <p>I have 2 sql servers in my local system with the instance name below</p>
  
  <pre><code>sql 2017 - MSSQLserver01
  sql 2014 - MSSQLServer
  </code></pre>
  
  <p>the 2 services are running perfectly. when i tried to connect to sql 2014 with SSMS 2017 with "localhost" as servername i can able to login to server with sa username. But when i tried to connect as "localhost\MSSQLServer" i am getting connection string error 87. also if i tried to connect 2017 server as "localhost\MSSQLServer01" i can able to connect.</p>
  
  <p>let me know is there any setting/configuration i am missing for sql 2014 installation.</p>