如何清除此错误 [英] How Do I Clear This Error
问题描述
TITLE:Microsoft SQL Server Management Studio
------------------------------
为数据库'myworld'创建失败。 (Microsoft.SqlServer.Smo)
如需帮助,请单击:http://go.microsoft.com/fwlink?ProdName = Microsoft + SQL + Server&ProdVer = 10.50。 2500.0 +((KJ_PCU_Main).110617-0026 +)&EvtSrc = Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID = Create + Database&LinkId = 20476
--- ---------------------------
附加信息:
执行Transact-SQL语句或批处理时发生异常。 (Microsoft.SqlServer.ConnectionInfo)
--------------------------- ---
数据库'master'中的CREATE DATABASE权限被拒绝。 (Microsoft SQL Server,错误:262)
如需帮助,请单击:http://go.microsoft.com/fwlink?ProdName = Microsoft + SQL + Server&ProdVer = 10.00.2531&EvtSrc = MSSQLServer&EvtID = 262&LinkId = 20476
------------------------- -----
按钮:
OK
---------- --------------------
i只需通过此权限创建即sql server authentication
TITLE: Microsoft SQL Server Management Studio
------------------------------
Create failed for Database 'myworld'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0026+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.2531&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
i need to create through this permission only that is sql server authentication
推荐答案
显然,您的 SQL Server 登录没有创建数据库的权限。 SQL Server 登录必须是 sysadmin 或 dbcreator 服务器角色的成员才能执行此操作。
示例:
将名为用户的 SQL Server 登录添加到dbcreator固定服务器角色(使用具有管理权限的帐户):
Hi,
Apparently, your SQL Server login doesn't have a permission to create a database. SQL Server login must be a member of the sysadmin or dbcreator server role in order to do that.
EXAMPLE:
Add a SQL Server login named User to the dbcreator fixed server role (using an account with administrative rights):
USE master;
GO
EXEC sp_addsrvrolemember 'User', 'dbcreator';
GO
更多信息: sp_addsrvrolemember(Transact-SQL) [ ^ ]
这篇关于如何清除此错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!