“The IP Address ‘x.x.x.x’ is already in use. To continue, specify a different IP address” SQL Server 2008 cluster setup error

Today I want to talk about my experience with one of the most strange setup errors installing SQL Server in a cluster. In this particular case I was helping the customer to install a new SQL Server 2008 R2 instance in a three-node cluster. The Windows cluster was already running with two instances, each one…

3

“OnlineThread: SQL Cluster shared data upgrade failed” error (ID 19019) installing Cumulative Update in SQL Server cluster

Last week I was working with a customer on this obscure SQL Server error right after installing Cumulative Update 9 (CU9) on a SQL Server 2008 two-node cluster. As you will see, the root-cause of the problem was easy to understand, but getting to the point of finding this root-cause was not. In this case…

5

Unexpected Behavior Setting Up Firewall Rules with Clustered SQL Server Instances

If you have ever try to setup firewall rules in your network to manage access to SQL Server you have probably found a somehow weird behavior when connecting to a clustered instance. In this particular case my customer was finding that the rules she had configured on her Windows firewall were working fine when connecting…

0

“Failed to find a cluster group that owned shared disk” SQL Server 2005 setup error

I think it could be interesting to share this SQL Server 2005 setup error since the message written in the setup logs was not clearly exposing the root-cause of the issue. In this case my customer was trying to update to Service Pack 3 (SP3) a SQL Server 2005 clustered instance. The error that we…

0

Do Not Use Cluster Server Recovery Utility on 64-bits Windows Server

You probably have heard about Cluster Server Recovery Utility before, a nice Windows utility that alleviate some of the burden associated with Cluster changes (restoring checkpoint files, changing disk signatures, storage migration, etc.). The Microsoft download page clearly states this utility is not suited for Windows Server 64-bits systems but I have recently found several…

0

How to Quickly Review your SQL Server Cluster Configuration on Windows Server 2003

Working at Microsoft Customer Support Services (CSS), we are frequently asked by our customers to check their SQL Server cluster configuration.  Event though the task of installing and configuring a SQL Server cluster have been simplified every new Windows Server version, it is not strange to find clusters with non-optimal configurations. Part of this problem…

0

"Unable to create computer account on DC" error installing SQL Server 2005 cluster on Windows Server 2008

Windows Server 2008 introduces significant changes to the Windows Cluster Service. The new Windows Cluster security model is one of the most important of these changes and will require seasoned SQL Server administrator to update her/his old-and-trusted knowledge. Some days ago I was facing a problem trying to install a SQL Server 2005 cluster on…

1

Using Windows Cluster log to troubleshoot SQL Server cluster errors

There are times where all the SQL Server knowledge in the world won’t help us to find a solution to our cluster problem. The following post will show you how to use the Microsoft Windows cluster log file to find the root-cause of a common SQL Server issue (it does not matter what SQL Server…

1

SQL Server Configuration Manager behavior in Clustered installation

According to Books Online reference "SQL Server Configuration Manager is a tool to manage the services associated with SQL Server, to configure the network protocols used by SQL Server, and to mange the network connectivity configuration". One of the greatest things about SQL Server Configuration Manager (SSCM for the sake of brevity) is that you…

0