SQL Server复制到Azure SQL数据库失败:提供服务器的实际名称 [英] SQL Server Replication to Azure SQL Database Failed: Provide the Actual Name of the Server

问题描述

大家好，

我正在使用Azure SQL数据库.免费试用订阅

I am using an Azure SQL database. Free Trial Subscription

我能够从SSMS(Management Studio)和门户查询编辑器连接到数据库.

I was able to  connect to the database from SSMS (Management Studio) and from Portal Query Editor.

我在本地SQL Server(SQL 2014)上配置了数据库发布者.一切正常，直到我选择创建一个Azure数据库订阅为止.当我尝试连接时，它会给我

I configured a database publisher on my local SQL Server (SQL 2014). everything works fine until i choose to create a subscription which is the Azure database . When i try to connect it gives me 

无法连接到myserver.database.windows.net. SQL Server复制需要实际的服务器名称才能建立与服务器的连接.指定实际的服务器名称myserver. (Replication.Utilities)

Cannot connect to myserver.database.windows.net. SQL Server Replication requires the actual server name to make a connection to the server. Specify the actual server name myserver . (Replication.Utilities)

我尝试了https://stackoverflow.com/questions/8212032/sql-server-replication-requires-the-actual-server-name-to-make-a-connection-to-t

I tried the solution from https://stackoverflow.com/questions/8212032/sql-server-replication-requires-the-actual-server-name-to-make-a-connection-to-t

，但它一直在说无法找到过程sp_addserver.不再受支持

but it keeps saying the Could not find procedure sp_addserver . it is no more supported

感谢任何帮助

推荐答案

法迪，

我不认为免费"试用版支持数据复制，但我正在对此进行调查.谢谢Mike

I don't think the 'Free' trial supports data replication but I am investigating this. Thank you, Mike

这篇关于SQL Server复制到Azure SQL数据库失败:提供服务器的实际名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！