I'm using ASP.NET Entity Framework's Code First to create my
database from the model, and the login seems to fail when the
database needs to be recreated after the model changes.
In Global.asax, I've got the following:
protected void Application_Start()
{
Database.SetInitializer(new DropCreateDatabaseIfModelChanges<EntriesContext>());
// ...
}
In my controller, I've got the following:
public ActionResult Index()
{
// This is just to force the
database to be created
var context = new EntriesContext();
var all = (from e in context.Entries select e).ToList();
}
When the
database doesn't exist, it is created with no problems. However, when I make a change to the model, rebuild and refresh, I get the following error:
Login failed for user 'sa'.
My connection string looks like this:
<add name="EntriesContext"
connectionString="Server=(LOCAL);Database=MyDB;User Id=sa;Password=password"
providerName="System.Data.SqlClient" />
The login definitely works as I can connect to the server and the
database from Management Studio using these credentials.
If I delete the
database manually, everything works correctly and the
database is recreated as expected with the schema reflecting the changes made to the model.
It seems like either the password or access to the
database is being lost.
Is there something else I need to do to get this working?
