SQL Server将数据库部署到Azure会抛出“您必须具有使用相同密码的用户...". [英] SQL Server deploy database to Azure throws "You must have a user with the same password..."

问题描述

我有一个实时SQL Server数据库，该数据库最初是Express版本，并具有100兼容性.我正在使用SSMS 2016 RC对其进行检查，它似乎具有最高的兼容级别120.

I have a live SQL Server database which was originally on an Express version and has compatibility 100. I am inspecting it using SSMS 2016 RC, which seems to have highest compatibility level of 120.

在执行任务将数据库部署到Microsoft Azure SQL数据库... 时，它会经过所有验证步骤，然后因错误而退出:

On performing the task Deploy Database to Microsoft Azure SQL Database... it goes through all the verification steps and then bails out with the error:

无法导入包.无法连接到主服务器或目标服务器X.您必须在主服务器或目标服务器X中拥有一个具有相同密码的用户.

Could not import package. Unable to connect to master or target server X. You must have a user with the same password in master or target server X

是升级数据库兼容版本的唯一解决方案，并且从旧版本开始甚至可行吗?我必须安装更新的SSMS来做到这一点吗?

Is the only solution to upgrade the compatibility version of the database and is that even possible from such an old level? Do I have to install a newer SSMS to do this?

我在下面看到了类似的问题，但它指的是SSDT，而不是SSMS: SSDT无法发布:无法连接到主服务器或目标服务器"

I've seen a similar question below, but it refers to SSDT, not SSMS: SSDT failing to publish: "Unable to connect to master or target server"

推荐答案

我安装了最新的SSMS v18.3并再次执行了部署操作，并且顺利进行，甚至不需要我更改兼容性级别

I installed latest SSMS v18.3 and performed the deploy operation again and it went through without a hitch, without even requiring me to change the compatibility level

这篇关于SQL Server将数据库部署到Azure会抛出“您必须具有使用相同密码的用户...".的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！