重新部署后，Azure SQL数据库凭据不断从模型中删除 [英] Azure SQL Database credentials constantly dropped from Model after redeployment
问题描述
你好
我们使用Azure Analysis Services和Azure SQL数据库构建了1400表格模型.在每个部署中(从Visual Studio中)，AAS中的凭据似乎都被删除了. SQL身份验证用于连接Azure SQL.所以只有在我登录AAS之后才可以使用 每次使用SSMS进行部署并在其中手动设置凭据.
We have built a 1400 Tabular model using Azure Analysis Services and Azure SQL Database. On every deployment (from Visual Studio) credentials in AAS seem to be dropped. SQL auth is used to conenct to Azure SQL. So it only works when i log into AAS after every deployment with SSMS and manually set credentials there.
我正在寻找一种设置CD的方法，但是找不到一种方法.有人可以建议吗?
I'm looking for a way to set up CD but can not find a way to do it. Can someone please advise:
1.也许有更好的方法可以针对Azure SQL数据库进行身份验证?
1. Maybe there is a better way to authenticate against Azure SQL Database?
2.如何部署该凭据不会丢失?
2. How to deploy that credentials would not get dropped?
3.有没有更好的自动部署方法?
3. Is there a better way to automatically deploy?
最诚挚的问候，
Martin
推荐答案
你好Martin_Tins，让我看看我是否理解这个问题:在部署过程中，您需要添加SQL凭据将用于连接到Azure Analysis Services和SQL数据库.一些您做事的方式并没有持久化 凭据，那么您必须手动连接并重新创建凭据，对吗?
Hello Martin_Tins, Let me see if I understand the question: During the deployment you need to add SQL credentials that are going to be used to connect to Azure Analysis Services and SQL Database. Some how the way you are doing it is not persisting the Credentials, then you have to connect manually and re-create the credentials, is this correct?
我不确定您当前如何添加凭证，但是可以添加将在部署期间运行的T-SQL脚本，以创建凭证.
I am not sure how are you currently adding the credential but you can add a T-SQL scripts that you will run during your deployment that will create the credential.
以下是一些有关使用TSQL创建凭据的文档
Here are some documentation on creating a credential using TSQL
不确定在部署期间是否要进行其他任何数据库更改，但是您可以背负该过程来运行脚本，也可以简单地创建其他部署后任务来对数据库进行更改.
Not sure if during the deployment, you are doing any other Database changes, but you can piggy back on that process to run your script or simply you create additional post-deployment task to make changes to your database.
希望获得帮助.
尊敬的
古斯塔沃·洛佩兹.
这篇关于重新部署后，Azure SQL数据库凭据不断从模型中删除的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
