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!
