Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Can't create table or database in sql server as permission denied in database master. Log in authentication is Windows authentication (./SQLEXPRESS)

share|improve this question

migrated from stackoverflow.com Jun 29 '12 at 16:29

This question came from our site for professional and enthusiast programmers.

1  
This belongs on Database Administrators SE. Flagged for migration. – Thomas Stringer Jun 29 '12 at 16:15

In order to create a database, you need to either be a part of the dbcreator fixed server role, or have either of the following permissions on the server: CREATE DATABASE, CREATE ANY DATABASE, or ALTER ANY DATABASE.

The fact that you are using Windows Auth is a neutral point, as within SQL Server it is a principal that still needs the required permissions to perform the necessary actions.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.