问题描述
我在名为Com1的本地计算机中有一个名为DB1的数据库.
我想对名为Ser1的远程服务器中另一个名为DB2的数据库上的DB1进行任何操作
可以使用IP通过Internet访问Ser1,或者可以在Ser1和Com1之间建立VPN网络
我想在Com1上的Sql服务器和Ser1上的Sql服务器之间进行事务复制
我知道有一个发布者,订阅者和分发者
据我了解,我将在Com1上创建分发服务器和发布者,并在Ser1上创建订阅服务器
我有SQL SERVER企业版评估180天
当我尝试在本地计算机上测试事务复制以使DB2也是Com1上的数据库时,它也成功了
但是,当我尝试在Ser1上使订阅服务器并且他要求发布服务器时,我输入了Com1的IP,但他拒绝了IP,并要求提供服务器的实际名称
我试图在Sql配置管理器上创建别名并使用该别名的名称,但他拒绝了它也需要服务器的名称
我尝试使用Com1所在的同一网络中的Com2,并以Com1的名称作为发布者,他成功创建了复制,但是当复制运行时,由于错误而失败,无法到达发布者
我现在该怎么办?并且是评估版不支持远程复制
I have a database called DB1 in a local computer called Com1
i want to make any action happened on DB1 on another database called DB2 in a remote server called Ser1
Ser1 can be accessed over internet using IP or i can to make VPN network between Ser1 and Com1
i want to make a transaction replication between the Sql server on Com1 and Sql server on Ser1
i know that there is a publisher and subscriber and Distributor
as i understood i will create the Distributor and the publisher on the Com1 and the subscriber on Ser1
i have SQL SERVER ENTERPRISE EDITION EVALUATION 180 days
when i tried to test the transaction replication on a local computer to make DB2 is a database on Com1 too it succeeded
but when i tried to make the subscriber on Ser1 and he asked for the publisher i enter the ip of the Com1 but he refuse the ip and ask for the actual name of the server
i tried to make alias on Sql configuration manager and use the name of this alias but he refuse it too need the name of the server
i tried with Com2 that is in the same network of Com1 and put the name of Com1 as publisher he succeeded to create the replication but when the replication run it failed by error can not reach the publisher
what must i do now? and is the evaluation edition do not support remote replication
推荐答案
这篇关于将数据从sql server数据库复制到另一台服务器中的另一数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!