2 active instances on 2 nodes at the same time SQL 2k5 Standard



I have a vendor telling me that I need the Enterprise version of SQL 2005 in
order to run an active/active cluster and that I can only run an
active/standby cluster on the standard version.

I've set up many clustered SQL servers on SQL 2000 Standards a few years ago
and never ran into any active/active or active/passive or questions.

I know I can only run 2 nodes in SQL 2k5 Standard.

Is there any reason that I can NOT run a 2 node cluster with separate but
active instances on both nodes at the SAME TIME on the Standard version of
SQL 2005?

E.G., instance A active on node 1 and instance B active on node 2 at the
same time on SQL 2005 standard?

Or do I need Enterprise level to do this?

Thanks,
Tim
.



Relevant Pages

  • RE: 2 active instances on 2 nodes at the same time SQL 2k5 Standard
    ... active/standby cluster on the standard version. ... I've set up many clustered SQL servers on SQL 2000 Standards a few years ago ... I know I can only run 2 nodes in SQL 2k5 Standard. ...
    (microsoft.public.sqlserver.clustering)
  • Re: 2 active instances on 2 nodes at the same time SQL 2k5 Standard
    ... but not to run a 2 node cluster. ... active/standby cluster on the standard version. ... I've set up many clustered SQL servers on SQL 2000 Standards a few years ... I know I can only run 2 nodes in SQL 2k5 Standard. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cost of ownership: MV vs. SQL Server
    ... >>If you are using SQL against MV, for example, ODBC would be your best ... > the alternative "Zero Touch Deployment" available with .NET. ... non-MS client environments? ... > as "standard" as any connectivity tool is going to get in our market. ...
    (comp.databases.pick)
  • Re: So whats null then if its not nothing?
    ... Because way too many people started writing half-baked study books about ... SQL when it became booming business. ... >"A good standard survives because people know how to use it. ... But I've also seen you write that it's equal to the empty ...
    (comp.databases.theory)
  • Re: SBS2008 install from my MS Action Pack
    ... SBS Standard with X CALS allows X users to use the SBS Standard Server. ... SQL Server with X CALS allows X users to use the SQL, ...
    (microsoft.public.windows.server.sbs)