在 SQL Server 2005 中创建数据库
安装SQL Server 2005后，我尝试创建一个新数据库（命令：create database database_name）。但该消息是一个错误：在“master”数据库中创建数据库的权限被拒绝。我的问题是 1.) 如何退出此主数据库并在其外部创建一个新数据库，2.) 什么是主数据库。
After installing SQL Server 2005, I tried to create a new database (command: create database database_name). But the message was an error: permission denied to create a database in 'master' database. My question is 1.) how to exit this master database and create a new database outside it, 2.) what is a master database.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
您需要使用sa帐户（系统管理员）登录，该帐户应具有所有权限。从那里，您可以根据需要创建其他帐户。
要创建新数据库，最简单的方法是使用 SQL Server Management studio，您可以右键单击“数据库”（在左侧窗格中）并选择创建新数据库。
“主数据库”基本上只包含元数据信息（即有关所有其他数据库的信息等）
You need to Log in using sa account (system administrator), which should have all permissions. From there, you can create additional accounts as needed.
To create a new database, the easiest way is to use SQL Server Management studio, and you can right click on "Databases" (in the left pane) and choose to create a new database.
The "master database" just basically contains the metadata information (i.e. info about all the other DBs, etc.)
master数据库是您登录的默认数据库。听起来您没有设置权限。刚刚开始的最简单的修复方法是以管理员身份运行 Mgmt Studio。有关修改权限的正确方法，请查看此处：http://msdn.microsoft .com/en-us/library/bb326612.aspx。
The master database is the default database to which you log in. It sounds like you don't have permissions set up. The easiest fix to just get started is to run Mgmt Studio as admin. For the right way to modify permissions, look here: http://msdn.microsoft.com/en-us/library/bb326612.aspx .
SQL Server 在主数据库中维护了大量有关 SQL Server、数据库、文件、登录名等的元数据。主数据库是心脏& SQL Server 正常工作的关键。
必须使用主数据库来创建新的用户生成的数据库。您使用的登录名似乎没有主数据库的权限或没有创建新数据库的权限。确保您有足够的权限来创建数据库并将自己添加到 db_creator 角色或更高级的 sysadmin 角色。
我不建议您使用 SSMS 创建新数据库。我会使用 T-SQL 脚本，因为您将拥有更多控制权。创建数据库后，请确保已关闭 AUTO SHRINK。另请确保您已将初始文件大小设置得足够大，以便文件不会自动增长。还要确保您将自动增长设置得足够长，这样它就不会以较小的增量增长。
SQL Server maintains lot of meta-data about SQL Server, databases, files, logins etc in the master database. Master database is the heart & key for SQL Server to work properly.
One has to use master database to create new user generated databases. It looks like the login you are using doesn't have permissions to the master database or doesn't have permissions to create a new database. Make sure you have enough permissions to create the database and add yourself to db_creator role or the higher level sysadmin role.
I wouldn't recommend you to use SSMS to create a new database. I would use the T-SQL script as you will have more control. Once you have created the database, make sure you have turn-offed AUTO SHRINK. Also make sure you have set the initial file size large enough so that the files will NOT auto-grow. Also make sure you have set the auto-grow long enough so that it won't grow in small increments.