Re: 2 Default instances on Active/Active

Tech-Archive recommends: Fix windows errors by optimizing your registry

Dunno if you are crazy, but you are correct. There is only one default instance per cluster. The restriction has to do with the directory structure for multiple instances rather than the IP address structure. Clustering mirrors the stand-alone multiple instance directory structurem except copied to each node.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP



"Himanshu" <Himanshu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:F9FD0F38-8DA8-4A00-8B73-A49B72477EE8@xxxxxxxxxxxxxxxx
I just setup my first 2 node Active/Active SQL Cluster and from what I can
tell you can have only one (1) default instance in an Active/Active cluster.
The other instance has to be a named instance. Is this correct, or am I crazy?

If so, I don't undertand why this limitation. Since the 2 SQL Servers will
always listen on 2 different IP addresses, and both are listening on port
1433, why can't I have 2 Default Instances? Is there a work around where I
can fool the cluster into having two Default Instances?

Thank you for reading this post - and all replies are very much appreciated :)



.

Relevant Pages

  • Re: Findfirst findnext
    ... In particular, it is part of filesystems FAT12, ... >next cluster if any. ... Personally I would say that the Directory structure is part of the ...
    (comp.lang.pascal.delphi.misc)
  • Re: 2 Default instances on Active/Active
    ... named instances on Active/Active cluster, ... on a different TCP port and/or pipe name. ... on a separate node, and each is listening on TCP 1433, whenever a failover ...
    (microsoft.public.sqlserver.clustering)
  • Re: I am having problems setting up a cluster
    ... You are not crazy, but the error message is 100% correct. ... > boxes will be used as print server I created the drives on ... > through the cluster process it's having problems finding ... > cannot be on the same controller as the operating system. ...
    (microsoft.public.windows.server.clustering)
  • Re: SunRPC on windows server 2003
    ... On my cluster servers and DC's they don't listen on sunrpc. ... are listening on Sunrpc which should be port 111. ...
    (microsoft.public.windows.server.general)
  • Non-cluster aware application listening on wrong port
    ... I have a custom application that I am being asked to cluster. ... appears to grab the local phyiscal nic's ip address and starts ... listening on that nic's ip address and not on the virtual IP's assigned ...
    (microsoft.public.windows.server.clustering)