Sample Header Ad - 728x90

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