title: How can I connect to a local ODBC datasource
body: <p>I created an ODBC database on my local machine with driver SQL server Native client 10.0, which connects to a remote server, see </p>
  
  <p><img src="https://i.stack.imgur.com/UBL4d.png" alt="ODBC Data Source">.</p>
  
  <p>I am working on a project about customized ODBC to an inhouse database and want to Test how I can connect to a data source using ODBC. 
  The question is how can I connect to the local ODBC using sql server studio manager?  I tried </p>
  
  <p><img src="https://i.stack.imgur.com/c8KCJ.png" alt="Sql Server studio manager to connect"></p>
  
  <p>but it returns an error:</p>
  
  <blockquote>
    <p>A network-related or instance-specific error occurred while
    establishing a connection to SQL Server. The server was not found or
    was not accessible. Verify that the instance name is correct and that
    SQL Server is configured to allow remote connections. (provider: Named
    Pipes Provider, error: 40 - Could not open a connection to SQL Server)</p>
  </blockquote>
  
  <p>Any idea?</p>