sql-server - Azure SQL Server BACPAC 导入失败

Question

每当我尝试在本地 SQL 服务器上导入 BACPAC 时，我都会收到以下错误消息:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Could not import package.
Warning SQL0: The source contains users that rely on an external authentication provider that is not supported by the target. These users will be treated as users without logins.
Warning SQL72012: The object [DB_NAME_Data] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that are not in the source' check box.
Warning SQL72012: The object [DB_NAME_Log] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that are not in the source' check box.
Error SQL72014: .Net SqlClient Data Provider: Msg 33161, Level 15, State 1, Line 1 Database master keys without password are not supported in this version of SQL Server.
Error SQL72045: Script execution error.  The executed script:
CREATE MASTER KEY;


 (Microsoft.SqlServer.Dac)

------------------------------
BUTTONS:

OK
------------------------------

之前在 SO 上报告的所有问题都与此不同。以前有人遇到过同样的问题吗？

Answer 1

尝试针对您的 master 数据库运行此操作(右键单击 SSMS 中的服务器名称 -> 新查询)

sp_configure 'contained database authentication', 1;
GO 
RECONFIGURE;
GO

此后，您可以再次执行导入 bacpac 向导，问题应该会得到解决。