Potential Problems to Watch Out for with SQL Server Failover Clustering

Many potential problems can arise during setup and configuration of SQL Server Clustering. Following are some items you should watch out for:

Image SQL Server service accounts and passwords should be kept the same on all nodes, or a node will not be able to restart a SQL Server service. You can use administrator or a designated account (for example, Cluster or ClusterAdmin) that has administrator rights within the domain and on each server.

Image Drive letters for the cluster disks must ...

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.