无法从辅助角色连接到SQLAzure主服务器-CannotconnecttoSQLAzuremasterfromworkerrole

2  

The issue with the master database turned out to be a red herring. The real issue was that I was using System.Data.SqlClient and Microsoft.SqlServer.Management objects to run a SQL batch script against the master (code in the style below).

master数据库的问题原来是一个红色的鲱鱼。真正的问题是我使用System.Data.SqlClient和Microsoft.SqlServer.Management对象来对主服务器运行SQL批处理脚本(下面样式中的代码)。

var serverCOnnection= new ServerConnection(sqlConnection);
var server = new Server(serverConnection);
server.ConnectionContext.ExecuteNonQuery(sql);

After much banging our heads against a wall, the issue turned out to be that the required dlls to use these libraries just did not work in Azure (we kept getting errors about missing dependencies).

经过多次撞墙之后,问题发现是使用这些库所需的dll在Azure中不起作用(我们不断收到有关缺少依赖项的错误)。

In the end, our solution to this was to break up the batch script into a number of subscripts (essentially splitting into parts wherever a GO statement was) and running using standard ADO.NET objects. This has turned out to be a better, more versatile solution so it has worked out OK for us after all!

最后,我们的解决方案是将批处理脚本分解为许多下标(实质上是在GO语句所在的地方分成部分)并使用标准ADO.NET对象运行。事实证明这是一个更好,更通用的解决方案,所以它毕竟对我们来说是好的!