Solved

Adding the Windows Cluster Service on a SQL2008 server

Posted on 2010-09-07
2
253 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Detach & Attach 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.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

760 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now