Take the 2-minute tour ×
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.

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

1 Answer 1

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.