sql - VSTS-Build for SQL Server 项目不起作用

Question

我有一个 Azure SQL Server 数据库，正在尝试将其放入 TFS 中。我已经创建了项目并导入了数据库，但是当我尝试在 Visual Studio 中进行构建时，出现以下错误:

"SQL71589: Master Key must be created before a database scoped credential".

Answer 1

您需要为数据库创建范围凭据。请参阅这篇 MSDN 文章:

https://learn.microsoft.com/en-us/sql/t-sql/statements/create-database-scoped-credential-transact-sql?view=sql-server-2017

根据您的场景，代码将如下所示:

-- Create a db master key if one does not already exist, using your own password.  
CREATE MASTER KEY ENCRYPTION BY PASSWORD='<EnterStrongPasswordHere>';  

-- Create a database scoped credential.  
CREATE DATABASE SCOPED CREDENTIAL AppCred WITH IDENTITY = 'dbUserNameFooBar',   
    SECRET = '<EnterStrongPasswordHere>';  
GO

希望有帮助。