title: MVC 3 - Writing to productive Database on SQL Server 2005 does not work (testing on local SQL Server 2008 does work)
body: <p>I'm a bit confused. I built my MVC 3 project which works fine in my development environment and the integrated IIS in Visual Studio 2010.</p>
  
  <p>After deploying it to an IIS 7 it seemed to work, too. Reading does. But when I try to change some database values, it simply does not do anything. It seems to work, but after a reload of the changed values, they aren't changed at all.</p>
  
  <p>Development database is on a local MS SQL Server 2008 and production on a remote Server with SQL Server 2005 (in this case, but the version will differ later on). Is there any difference? The user in the connection string has full rights, since changing works via Management Studio.</p>
  
  <p>The connection string looks like this:</p>
  
  <pre><code>&lt;add name="MyDBEntities"
    connectionString="metadata=
                      res://*/Models.MyDB.csdl|
                      res://*/Models.MyDB.ssdl|
                      res://*/Models.MyDB.msl;
                      provider=System.Data.SqlClient;
                      provider connection string=&amp;quot;
                      data source=10.90.0.88;
                      initial catalog=MyDB;
                      persist security info=True;
                      user id=foo;
                      password=bar;
                      multipleactiveresultsets=True;
                      App=EntityFramework&amp;quot;"
    providerName="System.Data.EntityClient" /&gt;
  </code></pre>
  
  <p>Thanks in advance.</p>
  
  <p>PS: I build the project with Entity Framework 4.1 which is installed on the server. Well, reading does work though...</p>