Sql Server 2000 Clustering Problem

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Sql Server 2000 Clustering Problem

Author

Topic

vassilisk
Starting Member

3 Posts

Posted - 2009-03-18 : 04:41:08

Hi there,

I have the following situation:

I had an SQL Server 2000 Cluster with 2 nodes (Active/Passive), and one of its nodes crashed. I evicted the node, disjoined it etc and left the cluster with one node. Both nodes used to run Windows 2000 Advanced Server. I set up the node with Windows 2003 Server Enterprise, joined the CLuster Successfully and I am in the process of trying to join the SQL Virtual Server as a failover clustering node. I run the setup from the cd and when i try to add the node it shows my node as "unavailable". I searched and Microsoft says: "If the node is listed as unavailable, you must modify the disk resources in the cluster group of the virtual server so the disk is available for the node you want to add to the Microsoft® SQL Server™ configuration. Click Next." But how can I actually do that? The Quorum and the 2 other disks are in a single resource which cannot be failed over, not even taken offline. Any help please?

natishkc
Starting Member

29 Posts

Posted - 2009-03-18 : 09:20:29

Let me know what service you have started related to cluster.

and let me know your ip (Cluster, MSDTC, SQl server)

Natish

vassilisk
Starting Member

3 Posts

Posted - 2009-03-18 : 09:34:41

I have not set up this cluster, just found it here. So let me put it another way. Just tell me what steps do I need to take in order to make this work. :) I have a single node SQL Server 2000 CLuster now, running on Windows 2000 Server and I want a Windows 2003 Server running SQL Server 2000 to join it. Cluster configuration:

NODE 1 (BEWSSQL1) IP (WINDOWS 2000): 10.1.51.30
NODE 2 (BEWSSQL2) IP: (WINDOWS 2003): 10.1.51.31

THERE IS ONLY ONE CLUSTER GROUP WITH THE FOLLOWING RESOURCES:

DISK Q: S: T: -> PHYSICAL DISK RESOURCE
CLUSTER IP ADDRESS -> 10.1.51.32
CLUSTER NAME -> BECLUSTER
SQL IP ADDRESS -> 10.1.51.33
SQL NETWORK NAME -> BEVIRTUALSQL
SQL SERVER
SQL SERVER AGENT
SQL SERVER FULLTEXT
MSDTC

THANX IN ADVANCE FOR ANY HELP!

natishkc
Starting Member

29 Posts

Posted - 2009-03-18 : 09:46:38

Dear First install DTC services than Cluster than SQl
While installing cluster be sure only one node should be online.

Put on ip to MSDTC also

Give authentication to SQL runing services, clust service and dtc. (domain\username password)

check this url

http://download.oracle.com/docs/html/A96687_01/manage.htm#i1005609

Natish

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources