CODEWITHSUNDEEP
asp.netasp.net-mvcdatabasepublish
Commongrate
Commongrate

Reputation: 123

My database isn't deploying with my MVC application

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.

Upvotes: 1

Views: 128

Answers (2)

Hasitha
Hasitha

Reputation: 152

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

Upvotes: 1

David Wong
David Wong

Reputation: 7

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.

Upvotes: 1

Related Questions