title: Which permissions does the local service account have, by default, when accessing an un-configured database in SQL Express 2008?
body: <p>I have an SQL Express 2008 R2 instance running under the "Local System" account. I have written a windows service that also runs under the "Local System" account. The windows service uses the following connection string to connect to the sql server.</p>
  
  <pre><code>Data Source=.\sqlexpress;Initial Catalog=mydatabase;Integrated Security=True
  </code></pre>
  
  <p>When the application is installed I create the database with a simple SQL script which does not set any permissions or roles...it just creates the database and tables.</p>
  
  <p>How does my windows service running as "Local System" manage to access the database? What rights is it getting in the SQL database? How is it getting these rights?</p>
  
  <p>Andrew</p>