title: EF 4.1 CF + Azure: CREATE DATABASE permission denied in database 'master'
body: <p>I have an ASP.NET WebForms application which uses EF 4.1 Codefirst.
  Running my application the first time creates a new database, tables etc.
  Everything has been working fine so far.</p>
  
  <p>But after adding my application as a WebRole to an Azure Project I got an error message when I first hit the database (CREATE DATABASE permission denied in database 'master').</p>
  
  <p>Obviously it makes a difference if I start my application inside the VS Development Webserver or inside the Azure Emulator.</p>
  
  <p>Here is some additional information which I believe could be relevant:</p>
  
  <ul>
  <li>The database does NOT exist when I run the application</li>
  <li>Visual Studio 2010 run as Administrator</li>
  <li>Trust level of my web role: Full trust</li>
  <li>SQL Server service (MS SQL 2008 R2 Express) is up and running</li>
  </ul>
  
  <p>The connection string in my web.config looks like this:  </p>
  
  <pre><code>&lt;add name="dbContext" connectionString="server=(local)\SQLEXPRESS;database=myDB;Integrated Security=True;MultipleActiveResultSets=True" providerName="System.Data.SqlClient" /&gt;
  </code></pre>
  
  <p>I also tried using a real user instead of "integrated security". And that user had all possible database roles assigned, including sysadmin, serveradmin etc.</p>
  
  <p>How I can I grant the necessary permissions to my application in order to allow creating a database while running inside the Azure emulator?</p>
  
  <p>Thanks so much for your help!</p>