Replication SQL Server to a Cluster with error
0
votes
1
answer
188
views
I have a source DB MSSQL Server and deploy transactional-replication
to a cluster with 2 Node(A&B).
The subscriber was added using SQL IP of Cluster and using "sa" account.
It run fine when server A active and server B passive.
When i shutdow the server A the replication stop and show error:
The process could not connect to Subscriber 'AHTDWHSQL'. (Source:
MSSQL_REPL, Error number: MSSQL_REPL0)
Get help: http://help/MSSQL_REPL0
Named Pipes Provider: Could not open a connection to SQL Server .
(Source: MSSQLServer, Error number: 1326)
Get help: http://help/1326
A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. (Source: MSSQLServer, Error number: 1326)
Get help: http://help/1326
Login timeout expired (Source: MSSQLServer, Error number: HYT00)
Get help: http://help/HYT00
Asked by Danis Lam
(1 rep)
Sep 10, 2019, 04:15 AM
Last activity: Jun 19, 2025, 08:03 PM
Last activity: Jun 19, 2025, 08:03 PM