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屋!