Hi
final question for now! I have installed an active passive 2 node cluster and it works fine. What things should I look out for which don't behave the same way as when you have a normal non-clustered installation? I realise this is a vague question, but any advice would be welcome
TIA
Fred

When you move the group(s) the applications are not available. Most
applications are fine with this, but some are not.

Also, you will run on a different MAC after a failure or Move group.

That is all I think of on a Saturday

Cheers,

Rod
"Fred" <anonymous (AT) discussions (DOT) microsoft.com> wrote

same way as when you have a normal non-clustered installation? I realise
this is a vague question, but any advice would be welcome.

If you're new to clustering, these references should help you out:

SQL Server Books Online (BOL)
SQL Server 2000 Clustering Whitepaper,
http://www.microsoft.com/SQL/techinf...overcluster.as
p
254321 INF: Clustered SQL Server Do's, Don'ts, and Basic Warnings
http://support.microsoft.com/?id=254321
260758 INF: Frequently Asked Questions - SQL Server 2000 - Failover
Clustering http://support.microsoft.com/?id=260758
815431 PRB: Installation of a Named Instance of SQL Server 2000 Virtual
Server http://support.microsoft.com/?id=815431
327322 PRB: SQL Server 2000 Enterprise Manager Polling May Cause
ClientToken http://support.microsoft.com/?id=327322
325485 WebCast: Microsoft SQL Server 2000 Virtual Server Basic Setup
http://support.microsoft.com/?id=325485
274446 INF: Upgrade to SQL Server 2000 Failover Solution Recommended for
All.... http://support.microsoft.com/?id=274446
233332 INF: How To Run SQLDIAG On a Clustered/Virtual SQL Server
http://support.microsoft.com/?id=233332
243218 INF: Installation Order for SQL Server 2000 Enterprise Edition
http://support.microsoft.com/?id=243218
319723 INF: Kerberos Support for SQL Virtual Servers on Server Clusters
http://support.microsoft.com/?id=319723
307336 INF: How to Change a Clustered SQL Server Network Name
http://support.microsoft.com/?id=307336
239885 INF: How to Change Service Accounts on a SQL Virtual Server
http://support.microsoft.com/?id=239885
244980 HOWTO: Change the Network IP Addresses on a Virtual SQL Server
http://support.microsoft.com/?id=244980
319016 HOW TO: Change Domains for a SQL Server 2000 Failover Cluster
http://support.microsoft.com/?id=319016
304282 PRB: Full Text Resource Fails to Come Online on a Cluster with
"Event ID... http://support.microsoft.com/?id=304282
270126 PRB: How to Manage Client Connectivity to Both SQL Server 2000
Virtual http://support.microsoft.com/?id=270126
298723 BUG: SQL Mail Not Fully Supported for Use in Conjunction with
Cluster http://support.microsoft.com/?id=298723
815431 PRB: You Cannot Successfully Install a Named Instance of SQL Server
2000 http://support.microsoft.com/?id=815431
305793 How to Replace a Disk That Is on a Windows 2000 or a Windows 2003
Server http://support.microsoft.com/?id=305793
216964 How to Administer a Server Cluster Remotely
http://support.microsoft.com/?id=216964
168801 How to Turn On Cluster Logging in Microsoft Cluster Server
http://support.microsoft.com/?id=168801
278007 Available Features in Windows Server 2003 Clusters
http://support.microsoft.com/?id=278007
258750 Recommended Private "Heartbeat" Configuration on a Cluster Server
http://support.microsoft.com/?id=258750

Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.