Edit

Bagikan melalui

The Microsoft support policy for clustered configurations of SQL Server with Windows Server

  • Artikel

This article describes the Microsoft support policy for clustered configurations of SQL Server with Windows Server.

Original product version:   SQL Server 2012 and later versions
Original KB number:   327518

Summary

This article describes the Microsoft support policy for SQL Server failover clustering. Microsoft supports SQL Server failover clustering that's based on the failover clustering features of the Windows Failover Cluster Service in the following products:

  • Windows Server 2012
  • Windows Server 2012 R2
  • Windows Server 2016 Standard and Datacenter Editions
  • Windows Server 2019 Standard and Datacenter Editions
  • Windows Server 2022 Standard and Datacenter Editions

Note

For Windows Server 2012 and Windows Server 2012 R2, see Microsoft support policy for Windows server failover clusters.

Windows Server provides the following types of clustering services:

Only the Server Cluster solutions can be used together with SQL Server for high availability if a node is lost or if a problem exists with an instance of SQL Server. Network Load Balancing may be used in some cases together with stand-alone read-only SQL Server installations. SQL Server Failover Cluster Instances each require a unique group. This requirement is true on cluster disk resources that use drive letters that are unique to the cluster and to each SQL Server Failover Cluster Instance. Each Failover Cluster Instance of SQL Server must also have at least one unique IP address. Depending on the version that is installed, multiple unique IP addresses may be possible. Additionally, each Failover Cluster Instance must have both virtual server and instance names that are unique to the domain to which the cluster belongs.

Cluster solutions other than Windows Failover Clustering

SQL Server was developed and tested using Microsoft Server Clustering. If you cluster it with any other clustering product, your primary contact for installation, performance, or cluster behavior issues should be the third-party cluster solution provider. Microsoft provides commercially reasonable support for third-party cluster installations as it does for stand-alone SQL Server.

Information of SQL Server 2012 and later versions

Mounted drives

The use of mounted drives isn't supported on a cluster that includes a Microsoft SQL Server installation. For more information, see SQL Server support for mounted volumes.

Cluster Shared Volumes (CSV)

Microsoft SQL Server 2012 and earlier versions don't support the use of CSV for SQL Server in a failover cluster.

To use CSV with SQL Server 2014 or later versions, check the following resources:

Use of Domain Controller Servers within Windows Server Failover Cluster (WSFC)

SQL Server failover cluster instances aren't supported on failover cluster instance nodes configured as domain controllers.

Migrating or changing SQL Server failover cluster instances to a new domain

SQL Server 2005 and later versions can't be migrated to a new domain. You need to uninstall and reinstall the failover cluster components. For more information about how to move a Windows Server cluster from one domain to another, see Move a Windows Server cluster from one domain to another.

Important

Before uninstalling SQL Server, the following steps should be taken:

  • Set SQL Server to use mixed mode security or add new domain accounts to the SQL Server logins.
  • Rename the DATA folder containing system databases so that it can be swapped back in after reinstallation to reduce downtime.
  • Don't remove any of the following components: SQL Server support files, SQL Server Native Client, Integration Services, or Workstation Components, unless you are rebuilding the entire node.

Warning

If errors occur during the un-installation process, you may need to rebuild the node to successfully install SQL Server again.

More information