Cluster manager hangs

We have two sql cluster nodes that works fine till lastweek. i can still move
the cluster goup manualy from the one node to the other. the problem is i
can't move the sqlgroup manualy to the other node. When i do that the sql
manager hangs and nothing happends till i reboot the node where the cluster
group is active than become the group active on the second node. The cluster
dont log anything in the event viewer or the clusterlog file that i cab use
to find the cause of this problem.
I need some help to solve this problem.
Thanks
From the context, by "cluster manager" and "sql manager", I take that you
meant "Cluster Administrator", and Cluster Administrator still reports the
state of the cluster properly, right? (e.g. you can view whether a group is
online and on which node the group is running, etc) In addition, the SQL
instance itself works fine, right?
I'd try to establish whether this is a Cluster Administrator tool problem or
the cluster/sql problem. Try tto move the SQL group using Cluster
Administrator on one of the nodes itself. Failing that, check to see whether
the cluster service works properly w.r.t. the SQL group. For instance, you
can deny the cluster service account access to the SQL instance, and this
will force the cluster service to bounce the SQL group between the nodes
(because its IsAlive check would fail) and eventually give up. If the cluster
does behave this way, I'd then focus on troubleshooting the Cluster
Adminitrator itself.
Linchi
"Saber" wrote:

> We have two sql cluster nodes that works fine till lastweek. i can still move
> the cluster goup manualy from the one node to the other. the problem is i
> can't move the sqlgroup manualy to the other node. When i do that the sql
> manager hangs and nothing happends till i reboot the node where the cluster
> group is active than become the group active on the second node. The cluster
> dont log anything in the event viewer or the clusterlog file that i cab use
> to find the cause of this problem.
> I need some help to solve this problem.
> Thanks
|||Hi Linchi,
Yes, i mean the cluster administrator. I have two clustergroups named "SQL
cluster group" running on Server1 and the "cluster group" running on
Server2. When i start the cluster administrator i can manualy move the
cluster group to server1 without problems. Failback is also working fine. But
when i try to move the SQL cluster group to Server2 the cluster administrator
hangs and the only way to get the SQL cluster group running on server2 is
taking server1 offline. the same problem occurs when i try to failback to
server 1.
The SQL cluster group contains the folowing resources:
-Disk R
-SQL IP address
-MSMQ
-SQL network name
-SQL server
-SQL Server agent
-SQL Server Fulltext
Also i did the following test:
When i take the SQL server resource offline i can move the SQL cluster group
between the 2 servers. and when i take the SQL server resource online again a
try the same the cluster administrator hangs.
Note: Server2 acts as 2003 DC and DNS server
Regards,
"Linchi Shea" wrote:

> From the context, by "cluster manager" and "sql manager", I take that you
> meant "Cluster Administrator", and Cluster Administrator still reports the
> state of the cluster properly, right? (e.g. you can view whether a group is
> online and on which node the group is running, etc) In addition, the SQL
> instance itself works fine, right?
> I'd try to establish whether this is a Cluster Administrator tool problem or
> the cluster/sql problem. Try tto move the SQL group using Cluster
> Administrator on one of the nodes itself. Failing that, check to see whether
> the cluster service works properly w.r.t. the SQL group. For instance, you
> can deny the cluster service account access to the SQL instance, and this
> will force the cluster service to bounce the SQL group between the nodes
> (because its IsAlive check would fail) and eventually give up. If the cluster
> does behave this way, I'd then focus on troubleshooting the Cluster
> Adminitrator itself.
> Linchi