"Novice of the database" failed to create database procedure, "master" denied CREATE DATABASE permission problem __ db

Source: Internet
Author: User
Tags create database

Problem Description: SQL Server Authentication Mode login, CREATE DATABASE error: "Master" rejected the Create DB permission issue.

Solution: First, re-login with Windows mode, click "Security-> Login", and then there will be a drop-down list of login names,




Then, double click on the sign-in name that you last failed, and the following interface appears:


Select "Server Role", then appear the following interface, all tick on the top (PS: Novice do not understand all tick)


You can then log in again with the authentication method, creating the database without error.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.