Solved

Adding the Windows Cluster Service on a SQL2008 server

Posted on 2010-09-07
2
259 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MSSQL join different row from other table 14 66
SQL Server 2008 R2 service pack updates 5 46
sql update 2 37
SQL Server 2008 Std. License Key owner or vendor 4 56
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

749 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