SQL Replication from a HA Cluster to a single SQL Server

Ben 21 Reputation points
2021-05-13T14:06:33.83+00:00

Hi, I wondered if it was possible to be able to replicate databases from a failover cluster with 2 nodes in to a separate server, When creating the replication publisher it says that I need to connect to the server directly but I'm not able to do so, only being able to connect via WIN-SQL-CLUST01;1433\SQLINSTANCE which is doesn't like. am I doing something wrong or is this just not a possible setup, in which case how could i get something like this to work?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,692 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
494 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
957 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,716 Reputation points
    2021-05-13T18:41:16.427+00:00
    0 comments
  2. Ben 21 Reputation points
    2021-05-14T07:33:22.267+00:00

    So I can actually enable the distributor but unable to actually create a local publication and get the message that it needs to be enabled as a publisher before you can create a publication however the distributor is configured but is showing the cluster access name in the publishers rather that the actual node that the database is on

  3. Alex Bykovskyi 1,681 Reputation points
    2021-05-15T06:39:34.447+00:00

    Hey,

    We have a guide covering similar configuration. 2 nodes in Failover Cluster holding primary replica of an Availability Group, while a standalone server holding secondary. Check the for more:
    https://www.starwindsoftware.com/resource-library/starwind-virtual-san-sql-server-hadr-using-availability-groups-and-failover-cluster-instance/

    Cheers,

    Alex Bykovskyi

    StarWind Software

    Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.