Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL2005 named instance can't be failed-over

0 views
Skip to first unread message

David Heer

unread,
Jun 9, 2010, 11:08:36 AM6/9/10
to

Howdy, all.

I've got a two-node (active/active) SQL 2005 cluster running on Server 2008
Enterprise on which a named instance (ICR) has been installed and is running
perfectly on node 2 of the cluster (the default instance runs on node 1 and
is easily failed-over to node 2). I am, however, unable to fail the named
instance over to node 1 of the cluster (the resource will change ownership
but fails to come online) and I suspect, smarty that I am, that it's because
the SQL services for the instance don't exist on node 1 as they do on node 2.

Does anyone have a suggestion as to what was missed during the named
instance installation/what can be done to create the missing services
entries?
--
Cheers!

David W. T. Heer

0 new messages