web api http get gives "Create Database permission denied in database master"

Question

I have a database called XyzDB. Everything is done and I am happy with it.

I have a WebAPI project which used Entity Framework (I generated my entity models from my database, so not code first).

When I use fiddler to query a table with a simple Get http method. I get the error:

Create Database permission denied in database master

However, I don't want to create a database. I just want to do a simple get method and return a json result.

Any help would really be appreciated.

The database exists? Are you using some database initializer like DropCreateDatabaseAlways or DropCreateDatabaseIfModelChanges? — Fals
– Fals, Commented Jul 20, 2015 at 19:56
I tried to search through the solution for the phrases you specified, but they are no where to be seen. So I guess the answer is no. — Francis Rodgers
– Francis Rodgers, Commented Jul 20, 2015 at 20:13
Then your database doen't exist at the specified server at the connectionString, and the user has no permision to create It — Fals
– Fals, Commented Jul 20, 2015 at 20:14
I just deleted the EF model and commented all the connection strings and then re-added it. Still same error. But the con string has to be right if I can read the tables and add them to the model etc. — Francis Rodgers
– Francis Rodgers, Commented Jul 20, 2015 at 20:31
Yeah...I'm a bit of a dumb head. :) I was connecting to my test server instead of my live one. The database on the test has a different name. Hence the errors. You were right, the database didn't exist. Thanks for your answers. — Francis Rodgers
– Francis Rodgers, Commented Jul 20, 2015 at 20:39

Anthony Brenelière · Accepted Answer · 2015-07-20 20:25:26Z

3

By default a DbContext creates the database if it does not exist, but does not perform a migration if the database already exist.

In the constructor of your DbContext, just add Database.SetInitializer( null ) in order to prevent generating the database.

You should also check your connection string in the App.Config because by default it connects to the master database. If it is Ole Db for Sql Server, add "initial catalog=[your database]" in order to connect to the right database.

http://www.connectionstrings.com/microsoft-ole-db-provider-for-sql-server-sqloledb/

answered Jul 20, 2015 at 20:25

Anthony Brenelière

63.9k16 gold badges49 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Francis Rodgers Over a year ago

I feel a bit dumb, I tried your Database.SetInitialaizer, after I got another error, which led me to the solution. Guess what...I was connecting to the wrong server and the database didn't exist. :) Thanks for your help.

Collectives™ on Stack Overflow

web api http get gives "Create Database permission denied in database master"

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related