本文介绍了发布Visual Studio数据库项目时出错:您必须在主服务器或目标服务器中拥有具有相同密码的用户的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

大家好,

盯着天蓝色的Paas - 网络应用程序连接数据库并遇到问题。当我尝试将在Visual Studio 2015中创建的sql数据库项目发布到中央美国sql
服务器实例上的sql数据库时,我花了相当多的时间并坚持解决这个问题。在一些教程中,它表明Visual Studio将在发布项目时使用向导添加当前客户端IP但不知何故这个向导并没有为我开始,所以为了添加客户端IP,我不得不在Azure门户上添加防火墙规则 -
各自的sql server并从0.0.0.0添加到255.255.255.255,它仍然给我同样的错误"无法连接到主服务器或目标服务器'kjahkjahs'。您必须在主服务器或目标服务器'kjahkjahs'中拥有具有相同密码的用户。我有
也尝试将sql server从sql server 2016转到azure V12但是没有帮助。 

Staring azure Paas - web app to connect with database and stuck in a problem. I have spent quite a bit of time and stuck to resolve this issue while I am trying to publish sql database project created in Visual Studio 2015 to sql database on central US sql server instance. In some tutorial it showed that Visual studio will add current client IP using a wizard while publishing project but somehow this wizard is not kicking off for me so in order to add client Ip, i had to add a firewall rule on Azure portal - respective sql server and added from 0.0.0.0 to 255.255.255.255, bit it still gives me same error that "Unable to connect to master or target server 'kjahkjahs'. you must have a user with the same password in master or target server 'kjahkjahs'. I have also tried chaging the sql server from sql server 2016 to azure V12 but that didnt help. 

我不知道还有什么可以尝试。任何想法将不胜感激。在此先感谢:) 

I am not sure what else to try. Any ideas will be greatly appreciated. Thanks in advance :) 

推荐答案

如果这不适合你,请告诉我们。

Please let us know if that doesn't work for you.


这篇关于发布Visual Studio数据库项目时出错:您必须在主服务器或目标服务器中拥有具有相同密码的用户的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

11-02 08:14