Solved

Adding the Windows Cluster Service on a SQL2008 server

Posted on 2010-09-07
2
258 Views
Last Modified: 2012-06-27
Hello,

I need to build an sql 2008 server, which we will "eventually" cluster.  I am wondering the best order to proceed with this installation.  Should I install the sql and install the cluster service later (when I have a second server,) or should I install and configure the cluster service without a fail over?  My server is running Windows 2008 R2.
0
Comment
Question by:bobsully53
2 Comments
 
LVL 2

Accepted Solution

by:
tspreeth earned 400 total points
ID: 33618613
Hi ,
To install sql cluster .
The steps will be .
1. Install the Cluster Component on the server . Windows Clustering Service.
2. Add the other server also on the Node.
3. The add cluster wizard will do this and test for cluster pre-requesties .
4. Only after above steps is done you can install the SQL . When you install SQL on the windows cluster the Cluster Dlls are installed at that time.
 
0
 
LVL 7

Assisted Solution

by:lundnak
lundnak earned 100 total points
ID: 33619379
I would complete your second choice.  Its much easier to add an additional node to the cluster at a later date.  You'd have less configuration to complete when you add the additional nodes.  Plus you will eliminate re-work on the original node.

That is the method that we generally use here.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server / Update DB? 22 36
TSQL XML Namespaces 7 21
SQLCMD Syntax 2 13
SQL - Simple Pivot query 8 11
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question