Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

ForeFront Client Security SQL Cluster

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

Looking for the Wi-Fi vendor that's right for you?

We know how difficult it can be to evaluate Wi-Fi vendors, so we created this helpful Wi-Fi Buyer's Guide to help you find the Wi-Fi vendor that's right for your business! Download the guide and get started on our checklist today!

Question has a verified solution.

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

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
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.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

604 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