Transactional Replication with updatable subscribers over the internet

  • I have created a publisher on server A. I need to create a subscriber on server B over the internet. For this i'm using VPN. While creating subcriber I get following message: "the initial snapshot for publication is not yet available". I suppose this is because of some permission issue to the snapshot folder which I have created on Server A. Do I need to have same windows authentication on both servers? As of now they are different as my servers are on different domains. Please help.

  • The following is from MSDN for SQL Server 2012. Please read the information at the top of the page.

    http://msdn.microsoft.com/en-us/library/ms151718.aspx

    I just want you to be aware that this feature is being deprecated and will be removed from a future version of SQL Server. If you are just now looking at implementing this, you may want to revisit what you are trying to accomplish and see if something like peer to peer transactional replication will provide the same functionality.

    http://msdn.microsoft.com/en-us/library/ms151196.aspx

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply