?
Solved

ForeFront Client Security SQL Cluster

Posted on 2008-06-26
3
Medium Priority
?
730 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 2000 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
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.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

770 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