title: Unable to connect pyODBC with SQL Server 2008 Express R2
body: <p>I am using following code to connect with SQL 2008 R2:</p>
  
  <pre><code>cnxnStoneedge = pyodbc.connect("DRIVER={SQL Server};SERVER=127.0.0.1;DATABASE=myDB;UID=admin;PWD=admin")
  </code></pre>
  
  <p>Which gives error:</p>
  
  <pre><code>Error: ('08001', '[08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (17) (SQLDriverConnect)')
        args = ('08001', '[08001] [Microsoft][ODBC SQL Server Driver][DBNE...t exist or access denied. (17) (SQLDriverConnect)')
        with_traceback = &lt;built-in method with_traceback of Error object&gt;
  </code></pre>
  
  <p>I am not sure whether SQL connecting via named Pipes or TCP, I did enable IP Address. Attaching Screen Shot
  <img src="https://i.stack.imgur.com/bB4S3.gif" alt="enter image description here"></p>