How WSFC Sets the Stage for SQL Server Clustering

Figure 42.5 shows an Excel spreadsheet that documents all the needed Internet Protocol (IP) addresses, network names, domain definitions, and SQL Server references to set up a two-node SQL Server failover clustering configuration (configured in an active/passive mode).

Image

FIGURE 42.5 An Excel spreadsheet for a two-node active/passive SQL failover cluster configuration.

USPETSDSQLTST01 is the first node, USPETSDSQLTST02 is the second node, and the cluster group name is USPETSDSQLCLUST (simple naming is used here to better illustrate the point). And the cluster network name is Cluster Network 1. This ...

Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.