在SQL Server 2008 R2中创建数据库
问题描述:
我安装了SQL Server 2008 R2.and编写查询CREATE DATABASE TEST来创建database.SQL给了我以下错误:
CREATE DATABASE权限被拒绝在数据库'master'中(Microsoft SQL server,错误:262)
I installed SQL server 2008 R2.and write query "CREATE DATABASE TEST" to create database.SQL gives me following error:
CREATE DATABASE permission denied in database 'master'(Microsoft SQL server,Error:262)
答
您需要检查安装并(根据您登录SQL实例的方式)正确设置用户权限。
看看这个: http:// www。 websense.com/content/support/library/web/v75/triton_web_help/permissions_3aSQL%20Server.aspx [ ^ ] - 它应该有帮助。
You need to check your installation and (depending on how you log in to your SQL instance) set the user permissions correctly.
Have a look at this: http://www.websense.com/content/support/library/web/v75/triton_web_help/permissions_3aSQL%20Server.aspx[^] - it should help.
在我看来,你有权限 [ ^ ]。
如需了解更多信息,请阅读:
校长(数据库引擎) ) [ ^ ]
SQL Server中的授权和权限 [ ^ ]
In my opinion, you have got a problem with permissions[^].
For further information, please read it:
Principals (Database engine)[^]
Authorization and Permissions in SQL Server[^]
尝试重新安装SqlServer并执行必要的步骤。
Try reinstalling the SqlServer and following necessary steps.