title: Set up and connect to local SQLEXPRESS database using SQL Server Management Studio 2008 r2 and adodbapi
body: <p>For testing purposes, I am attempting to setup a SQL Server database on my local machine and connect to it using adodbapi in Python.  I used SQL Server Management Studio 2008 r2 to create a database and table.  I enabled the SQL Server Browser service, but I am still unable to connect using adodbapi.  Using this connections string:</p>
  
  <pre><code>adodbapi.connect(r'Provider=SQLOLEDB;Data Source=COMPUTERNAME.\SQLEXPRESS;Initial Catalog=Test;User ID=userName; Password=password;')
  </code></pre>
  
  <p>I get the following error:</p>
  
  <blockquote>
    <p>Traceback (most recent call last):   File "", line
    1, in    File
    "C:\Python26\ArcGIS10.0\lib\site-packages\adodbapi\adodbapi.py", line
    307, in connect
        raise OperationalError(e, "Error opening connection: " + connection_string) OperationalError: (com_error(-2147352567,
    'Exception occurred.', (0, u'Microsoft OLE DB Provider for SQL
    Server', u'[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not
    exist or access denied.', None, 0, -2147467259), None), 'Error opening
    connection: Provider=SQLOLEDB;Data Source=COMPUTERNAME.\SQLEXPRESS;Initial
    Catalog=Test;User ID=userName; Password=password;')</p>
  </blockquote>
  
  <p>Any insight into what I'm missing?</p>