Entity Framework 7 code first error CREATE DATABASE permission denied in database 'master'

Question

I'm using vs2015 an vNext/Asp.net5 wint EF7. my config.json file has following value

"TestContextConnection": "Server=.\\SQLEXPRESS;Database=TestDb;Trusted_Connection=true;MultipleActiveResultSets=true"

Whenever I run this project I get the following error

CREATE DATABASE permission denied in database 'master'.

Can someone please explain, I don't know what user I'm referring here is it my active directory user or some other dbuser? also what rights I've to assign to what user in order this code to work successfully? what if I have to create a new user from scratch with all required permissions for this?

Thanks in advance.

Ryan Helmoski · Accepted Answer · 2016-01-06 03:40:16Z

1

Do you need to use the TestDb database on the SQLEXPRESS server, or are you just trying to get something up and running?

If you are just trying to get something up and running, try using the following for your connection string: Server=(localdb)\\MSSQLLocalDB;Database=<DATABASE_NAME>;Trusted_Connection=True;MultipleActiveResultSets=true

edited Jan 6, 2016 at 3:40

answered Jan 6, 2016 at 3:34

Ryan Helmoski

3692 silver badges7 bronze badges

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

1 Comment

afr0 Over a year ago

thanks for your help, I wanted to created new database.

afr0 · Accepted Answer · 2016-01-06 08:56:27Z

0

I figured out I was point to the wrong sql server instance on my machine. I corrected the server instance and my problem was resolved.

answered Jan 6, 2016 at 8:56

afr0

8881 gold badge11 silver badges29 bronze badges

Collectives™ on Stack Overflow

Entity Framework 7 code first error CREATE DATABASE permission denied in database 'master'

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related