My database isn't deploying with my MVC application

Question

After publishing my MVC app, my website is giving me this error:

Server Error in '/' Application.
CREATE DATABASE permission denied in database 'master'.

I have added the connection string, both in the web.config file and in the ASP.NET settings on the domain, this is the connection string:

Data Source=.;Initial Catalog=ADB;Integrated Security=True;User ID=MVCU;Password=MVCPASS

I have created a database in the domain's server, with the same Username and Password as it is in the connection string above.

The database itself only has the default login/registration tables, that MVC creates automatically.

score 1 · Answer 1 · answered Mar 21 '18 at 08:48

1

I think this is a repeat from the question CREATE DATABASE permission denied in database 'master' (EF code-first). But it should also answer your question.

answered Mar 21 '18 at 08:48

David Wong

Yea I had seen that, It doesn't answer my question because the database is created within visual studio, so I don't really know how to access its properties. – Commongrate Mar 21 '18 at 08:51
In Visual studio there is a side menu containing the data source, which should also contain your database. there you should be able to access the permissions, If it is a local database. If it is not local database then you will have to set it up on the database itself. Another suggestion is create a new database, Don't use master. Using Master isn't the best practice. – David Wong Mar 21 '18 at 08:56

score 1 · Accepted Answer · answered Mar 21 '18 at 18:32

1

In your connection string "Integrated Security" is set to true. Set it false and try again.

answered Mar 21 '18 at 18:32

Hasitha

Thanks, this helped, but I also had to add "./MSSQLSERVER2014" to the initial catalog, and it worked. – Commongrate Mar 21 '18 at 19:00
Glad to hear that! – Hasitha Mar 22 '18 at 06:53

2 Answers2