Potential Problems to Watch Out for with SQL Server Clustering
Many potential problems can arise during setup and configuration of SQL Server Clustering. Following are some items you should watch out for:
• 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.
• Drive letters for the cluster disks must be the same on all nodes (servers). Otherwise, you might not be able to access a clustered disk.
• You might have to create an alternative method to connect to SQL Server if the network name is offline and ...
Get Microsoft® SQL Server 2008 R2 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.
