DB First, MVC 4, CREATE DATABASE permission denied in database 'master'

Question

I keep getting this error on my server when I publish my site - even without changes in database model.

The site is running fine local.

I'm using the DB first approach.

If I delete all files in the site on the server, restore my local database on the server. Publish the site from VS. Sometime it will run fine after that.

If I then make a few changes in the database CONTENT I will get the error.

I don't whant to create any database/tables on the server - just disable the part of the code, that need to do it. In MVC3 we had this DropCreateDatabaseIfModelChanges but I can't see any of that in my current site.

What can I do?

My connectionstring:

    <connectionStrings>
     <add name="GoBagHomeComEntities"     connectionString="metadata=res://*/Models.GoBagHomeModel.csdl|res://*/Models.GoBagHomeModel.ssdl|res://*/Models.GoBagHomeModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=.\sqlexpress;initial catalog=GoBagHomeCom;Persist Security Info=True;User ID=xx;Password=xxxx;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient"
      xdt:Transform="SetAttributes" xdt:Locator="Match(name)"/>
     </connectionStrings>

And my dbcontext

public partial class GoBagHomeComEntities : DbContext
{
    public GoBagHomeComEntities()
        : base("name=GoBagHomeComEntities")
    {
    }

score 0 · Answer 1 · edited May 23 '17 at 12:29

0

Check dbo.__MigrationHistory if you have records means EF is trying to migrate, so truncate the table and try it again.

if the same thing repeated so you might need to check EF weather it migrates as settings.

have a look to this answer this, you need to have the connection string in web.config file, I think this is the only missed thing.

edited May 23 '17 at 12:29

Community

1
1

answered Oct 20 '15 at 07:41

Mahmoud Hboubati

1,007
11
26

I don't have that table – ThorOstergaard Oct 20 '15 at 07:57
**If I then make a few changes in the database CONTENT I will get the error.** Will you get error after the changes without publishing even? – Mahmoud Hboubati Oct 20 '15 at 08:28
Do you have Migrations folder in the solution? – Mahmoud Hboubati Oct 20 '15 at 08:49
Nope - it's a DB first solution – ThorOstergaard Oct 20 '15 at 09:02
Check the connection string property which is used in he context object, it might be different that the database, I have edited my answer by the way check the connections string in the web.config file. – Mahmoud Hboubati Oct 20 '15 at 10:42
Have added my connectionstring and dbcontext to my question. – ThorOstergaard Oct 20 '15 at 10:57

score 0 · Accepted Answer · answered Oct 25 '15 at 09:41

0

It seems like the problem is solved :)

I'm sure Owin was the bad guy - I was only using it for creating the authentication cookie. Nothing about tables.

After remove all Owin related code on the site it's running.

answered Oct 25 '15 at 09:41

ThorOstergaard

107
2
9

score 0 · Answer 3 · answered Jun 09 '17 at 09:51

If your bring any change in your database you should follow the following steps:

Update the .edmx file. To update it double click on .edmx when it will open, please right click on a blank space of this file and select "update model from database".
Save and close the file.
Build the project.
Copy .dll file from bin folder and past it where you have hosted your application.

DB First, MVC 4, CREATE DATABASE permission denied in database 'master'

3 Answers3