November 29, 2006 at 7:16 am
Hi All,
Is it possible to build an active/active 2005 cluster ?
Say I've got servers NODEA and NODEB and I want to create virtual servers NODEAV and NODEBV running on NODEA and NODEB respectively.
I've go a working active/passive cluster, I've specified 'Default Instance' on the Instance Name page, then I specified NODEAV on the Virtual Server Name page - now I have NODEAV running happily on NODEA.
Then I run the installer on NODEB and it detects that NODEAV has been installed and won't let me proceed. Any thoughts ?
I'm guessing that I need to specify a named instance on both sides. Is this correct ?
November 29, 2006 at 8:06 am
build windows cluster
install sql2005 as default instance
install sql2005 as named instance in another cluster group with different hard disk resources
keep default instance on one node and named instance on another node or any way you wish. i also like to fail everything over to one node when doing the install. fail over to node A, install default instance, fail over to node b and install other instance
November 29, 2006 at 10:09 am
Success, got this working.
Installed named instances on both nodes and it's fine. I suppose its quite logical that you can't install a named instance on both sides, as when one fails over - so one server runs both instances - you can't have two default instances on one box.
It wasn't explained at all well though, spend half the morning searching Google for answers. Anyway, sorted.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply