title: EF 4.1 CF: CREATE DATABASE permission denied in database 'master'
body: <p>Entity Framework 4.1 Code First works great with <code>SQLEXPRESS</code> on <code>localhost</code>. However, I'm now ready to connect to a regular <code>SQL 2008 server</code>. </p>
  
  <ol>
  <li><p>I created a new database "NewEfDatabase".</p></li>
  <li><p>Then changed my "<code>ApplicationServices</code>" <code>connectionString</code> in <code>Web.config</code> to point to my new database with integrated security. </p></li>
  </ol>
  
  <p>But then I get this error:</p>
  
  <p>"<code>CREATE DATABASE permission denied in database 'master'.</code>"</p>
  
  <p>So...</p>
  
  <p>a) What permissions does EF 4.1 CF need on said SQL server to do its work?</p>
  
  <p>b) Can I setup an empty database on <code>SQL 2008</code> for EF 4.1 CF, or do I have to let it do all that work for me? (I'm not sure my DBA would appreciate letting my EF app have rights to do anything outside a particular database)</p>