title: Cannot connect to MSSQL 2008 with ip 127.0.0.1
body: <p>I dont have much experience with MsSql. I have no problem to connect to database by SQL management studio with <code>SQL Server Authentication Mode</code> on ip <code>127.0.0.1</code>. 
  But my program fails to connect. I created file <code>connect.UDL</code> for test connection and got this error</p>
  
  <pre><code>[DBNETLIB][ConnetionOpen (Invalid Instance()).] Invalid connection
  </code></pre>
  
  <p>Some information may usefull</p>
  
  <ul>
  <li>SQL server is on configured as Mixed Authentication Mode</li>
  <li>DIsabled my firewall</li>
  <li>Enabled all protocols (Shared Memory, Pipe names, TCP/IP, VIA)</li>
  <li>Using 127.0.0.1 and 1433 port for TCP/IP protocol</li>
  <li>Allowing remote connection on server</li>
  </ul>
  
  <p>Can provide more information if you need. Thanks</p>
  
  <p><strong>EDIT :</strong> I deleted everything and installed SQL SERVER 2008 R2. Everything working now. Thanks all for your effort.</p>