Search code examples
sql-serverdatabase-replicationazure-sql-databasetransactional-replicationdatabase-mirroring

The process could not connect to Subscriber 'xxxxxx'

i have configured transnational push replication from SQL Server 2014 to Azure SQL Database publisher DB is also configured for mirroring.

i get The process could not connect to Subscriber 'xxxxxx' when i see in replication monitor in tab "distributor to subscriber" enter image description here

i have used windows user credential everywhere other then for connecting to azure sql database.

note: same setup from new server to same azure db. it works so may be some issue with my production server... i am not sure what? i got opened all ports listed here TCP: 21,80,139, 445 UDP: 137, 138 and also 1433

i am able to connect azure db in SSMS on the same server so azure is not blocking the ip

please help

Solution

  • Can you check the build version of your SQL Server 2014? Replication to SQL DB is supported in SQL Server 2014 SP1 CU3 or SQL Server 2014 RTM CU10 or higher version. Error MSSQL_REPL20084 and MSSQL_REPL40532 may indicate you are using an older version of SQL Server.