AWSRDSSQLServer无法删除数据库-AWSRDSSQLServerunabletodropdatabase

4  

I ran into this same issue. After trying to restore a database via SSMS using a .bacpac, it fails and leaves you with a database that you appear to not have permissions to drop.

我遇到了同样的问题。尝试使用.bacpac通过SSMS还原数据库后,它会失败,并为您提供一个您似乎无权删除的数据库。

A workaround, is to use the rdsadmin rename function to rename it to something else, which then seems to fix the permission issue and allows you to drop it.

解决方法是使用rdsadmin重命名功能将其重命名为其他内容,然后似乎修复了权限问题并允许您删除它。

EXEC rdsadmin.dbo.rds_modify_db_name N'', N''

Then just drop the DB. Hope that helps someone else in the same predicament.

然后放下数据库。希望能帮助其他人处于同样的困境。

0  

Sounds like your not a member of the correct role.

听起来你不是正确角色的成员。

https://msdn.microsoft.com/en-us/library/ee240822.aspx

Permissions

A DAC can only be deleted by members of the sysadmin or serveradmin fixed server roles, or by the database owner. The built-in SQL Server system administrator account named sa can also launch the wizard.

DAC只能由sysadmin或serveradmin固定服务器角色的成员或数据库所有者删除。名为sa的内置SQL Server系统管理员帐户也可以启动向导。

https://msdn.microsoft.com/en-us/library/ms178613.aspx

Permissions

SQL Server - Requires the CONTROL permission on the database, or ALTER ANY DATABASE permission, or membership in the db_owner fixed database role.

SQL Server - 需要对数据库具有CONTROL权限,或ALTER ANY DATABASE权限或db_owner固定数据库角色的成员身份。

Azure SQL Database - Only the server-level principal login (created by the provisioning process) or members of the dbmanager database role can drop a database.

Azure SQL数据库 - 只有服务器级主体登录(由配置过程创建)或dbmanager数据库角色的成员才能删除数据库。

Parallel Data Warehouse - Requires the CONTROL permission on the database, or ALTER ANY DATABASE permission, or membership in the db_owner fixed database role.

并行数据仓库 - 需要对数据库具有CONTROL权限,或者具有ALTER ANY DATABASE权限或db_owner固定数据库角色的成员身份。