title: Specified store provider cannot be found in the configuration
body: <p>When I publish my ASP.NET MVC 4, EF 5.0, Code-First Project to test or production environment following exception occurs:</p>
  
  <p>(error 0175: The specified store provider cannot be found in the configuration, or is not valid.)</p>
  
  <pre><code>    [MetadataException: Das angegebene Schema ist ungültig. Fehler: 
  (0,0) : Fehler 0175: Der angegebene Speicheranbieter kann nicht in der Konfiguration gefunden werden oder ist ungültig.]
     System.Data.Metadata.Edm.Loader.ThrowOnNonWarningErrors() +57
     System.Data.Metadata.Edm.StoreItemCollection.Init(IEnumerable`1 xmlReaders, IEnumerable`1 filePaths, Boolean throwOnError, DbProviderManifest&amp; providerManifest, DbProviderFactory&amp; providerFactory, String&amp; providerManifestToken, Memoizer`2&amp; cachedCTypeFunction) +206
     System.Data.Metadata.Edm.StoreItemCollection..ctor(IEnumerable`1 xmlReaders) +368
     System.Data.Entity.Migrations.Extensions.XDocumentExtensions.GetStoreItemCollection(XDocument model, DbProviderInfo&amp; providerInfo) +361
     System.Data.Entity.Migrations.Infrastructure.EdmModelDiffer.Diff(XDocument sourceModel, XDocument targetModel, String connectionString) +72
     System.Data.Entity.Migrations.DbMigrator.IsModelOutOfDate(XDocument model, DbMigration lastMigration) +194
     System.Data.Entity.Migrations.DbMigrator.Upgrade(IEnumerable`1 pendingMigrations, String targetMigrationId, String lastMigrationId) +328
     System.Data.Entity.MigrateDatabaseToLatestVersion`2.InitializeDatabase(TContext context) +150
     System.Data.Entity.Internal.InternalContext.PerformInitializationAction(Action action) +66
  </code></pre>
  
  <p>The database on the SQL server was created, and also the tables in the database.</p>
  
  <p>On the local dev environment everything is working fine. I locally installed the same MS SQL Express 2008 R2 version as on test/production. And locally everything is working.</p>
  
  <p>As I read on other with the same error (mostly with MySQL database), the error was fixed with including the binaries. But for MSSQL there are no special binaries to include (I think). And the database/tables are created, so the access to SQL server should be fine.</p>
  
  <p>Here is my web.config for production/test:</p>
  
  <pre><code>&lt;configuration&gt;
    &lt;configSections&gt;
      &lt;section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=5.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" /&gt;
    &lt;/configSections&gt;
    &lt;connectionStrings&gt;
      &lt;add name="NameOfContext" connectionString="Server=ServerName\MSSQL;Database=DatabaseName;User Id=Username;Password=Password" providerName="System.Data.SqlClient" /&gt;
    &lt;/connectionStrings&gt;
    &lt;appSettings&gt;
      &lt;add key="webpages:Version" value="2.0.0.0" /&gt;
      &lt;add key="webpages:Enabled" value="false" /&gt;
      &lt;add key="PreserveLoginUrl" value="true" /&gt;
      &lt;add key="ClientValidationEnabled" value="true" /&gt;
      &lt;add key="UnobtrusiveJavaScriptEnabled" value="true" /&gt;
    &lt;/appSettings&gt;
  ...
    &lt;entityFramework&gt;
      &lt;contexts&gt;
        &lt;context type="NameOfContext, Application name"&gt;
          &lt;databaseInitializer type="System.Data.Entity.MigrateDatabaseToLatestVersion`2[[NameOfContext, Application Name], [Name_App.Migrations.Configuration, Application Name]], EntityFramework, PublicKeyToken=b77a5c561934e089"&gt;
            &lt;parameters&gt;
              &lt;parameter value="NameOfContent" /&gt;
            &lt;/parameters&gt;
          &lt;/databaseInitializer&gt;
        &lt;/context&gt;
      &lt;/contexts&gt;
    &lt;/entityFramework&gt;
  </code></pre>