February 12, 2009 at 10:58 am
Hi All,
Just doing some research on SQL clustering, was wondering will SSMS be used to manage a cluster and how many IP addresses will be needed in a 2 node cluster.
Can someone point me to a good clustering article on SQL 2005.
Thanks
February 12, 2009 at 11:20 am
You can manage a cluster through Cluster Administrator only. This is available when you install MSCS ( Microsoft Clustering Services) on the windows server. This will enable you to list the nodes( servers) that are to be made part of the clutster.Once the windows cluster is built then SQL 2005 can be installed on the cluster.
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 12, 2009 at 11:22 am
As for the link for SQL 2005 Clustering, there is a good article by Richard Lu, you can refer it in the below link
http://www.sqlservercentral.com/articles/Clustering/62327/
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 12, 2009 at 12:00 pm
You can use SSMS to administer the clustered SQL Server instance in the normal way. To administer the actual cluster you use cluster administrator. SQL installs as a cluster resource and as part of the installation SQL Server is given an IP address and a name - when you later connect to the clustered SQL Server instance you connect to the cluster resource by name rather than the physical server it is running on.
February 12, 2009 at 1:53 pm
At a minimum, for a two node cluster hosting SQL Server you are going to have four IP addresses.
One for each node
One for the virtual cluster name
One for the virtual SQL cluster name
If you setup and configure MSDTC as a separate resource in it's own cluster group it will need it's own IP address.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 12, 2009 at 2:04 pm
Jeffrey Williams (2/12/2009)
At a minimum, for a two node cluster hosting SQL Server you are going to have four IP addresses.
six if you count the private NIC ip address too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2009 at 2:08 pm
Yes - that is correct, if you count the private addresses needed for the cluster heartbeat connection. Forgot about those 🙂
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 13, 2009 at 7:22 am
Microsoft has a SQL 2005 FOC document which can be downloaded from
February 18, 2009 at 4:39 am
Thanks all, this has been very useful.
February 18, 2009 at 6:08 am
the most complex part of the system is getting the cluster and its resouces in place, the rest is plain sailing
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply