Solved

ForeFront Client Security SQL Cluster

Posted on 2008-06-26
3
728 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
[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
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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

691 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