Solved

ForeFront Client Security SQL Cluster

Posted on 2008-06-26
3
726 Views
Last Modified: 2012-05-05
I guess I need to break this down into two questions:

1. ForeFront Client Security offer support to a two node SQL 2005 SQL Cluster

2. If so, how do you go about the installation onto your SQL Cluster.  Does the software have to be installed on both nodes?  I would assume so, but I would like to go on more than just an assumption.
0
Comment
Question by:LEAD Support
  • 2
3 Comments
 
LVL 38

Accepted Solution

by:
Jim P. earned 500 total points
ID: 21933551
There is no real short hand answer to this. Basically you have to have two Win 2K3 Enterprise Edition servers with dual NICs, a Quorum drive (both can access) and a shared drive array.

Search for "Microsoft Cluster Services" for the base installation info and then go onto MS SQL Server Cluster for the rest.

Note that there is not really such a thing as Active/Active SQL. The database can only be active on one node of a cluster at a time. You can have active instances on both  nodes at the same time, but not the same databases.
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 22058689
Glad to be of assistance. May all your days get brighter and brighter.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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.

825 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