locked
SQL merge replications fails only over VPN RRS feed

  • Question

  • Hey Folks,

    I planned and configured a VPN infrastructure (SSTP VPN with EAP) and now I have a problem with SQL merge replication over VPN. Our staff is using a local client app to collect som data. Sometimes they start within this app a replication to an SQL-Server in our Data Center. This is working very fine but it fails over VPN. I am a SQL greenhorn and need some help now.

    The error on the client says: "The process could not connect to Subscriber. Error: MSSQL_REPL20084. SQL Server Network Interfaces: Error Locating Server/Instance Specified (xFFFFFFF)".

    Event viewer on the SQL Server says: "Event ID 14151 Replication-Replication Merge Subsystem: agent XXX\SQLEXPRESS-61 failed. The process could not connect to Subscriber XXXX\SQLEXPRESS."

    Facts:

    - Windows 8.1 Clients

    - SQL Server 2012

    - SQL replication is working well in the local Area Network.

    - All Firewall Profiles are equaly configuired fpr replication.

    - VPN client can Ping SQL Server.

    - SQL Server can Ping VPN Client.

    Please can anyone give me a hint? And remember, SQL is a unknown world for me :)

    Thanks!

    Friday, August 22, 2014 5:04 AM

Answers