Cluster questions

First of all, excuse me if my English isn't too correct.

I need to install a portal infrastructure that was developed with ASP
and SQL Server. The system would like to be redundant and scalable.

To do that, I have in mind, the following diagram :

- 2 W2003 Servers with IIS6 and NLB ( frontend )
- 2 W2003 Servers with MS-SQL and MSCS with a SAN connected ( backend

I have read Microsoft and others documentation, and I have questions
that I would like to know.

I have worked with NLB and I understand how it works, but I'm new with
MSCS, and I must need to know to cluster SQL servers.

In SQL 2000, the cluster can be active/pasive or active/active.

If it is active/pasive, one of the two nodes, assumes all work, and
the second node is waiting that the first node goes down, when that
happens the second node assumes all work, this is the failover. Every
node has got one IP and the two nodes have a IP that they share (
Virtual Server), like NLB.

The ASP applications connect to the IP of Virtual Server. No problem.

The cluster is transparent to the ASP aplication.

But if I have active/active mode, the application must see two SQL
Server, not one like active/pasive mode, it's true ? The cluster isn't
transparent to the ASP aplication ?

The developement of the ASP application is different that the
active/pasive and active/active modes ?

With MSCS is possible to make the system scalable or only the failover
is possible ? If it's possible the scalability, is necessary to modify
the ASP developement or it's transparent ?

I read that MSCS is necesary that the servers must be joined in a
domain, it can't work in a Workgroup.

If I install AD in the 2 web servers, the performance will decrease,
there won't be users and permissions, it's only a web portal.
Is it possible to work in a Workgroup ?

And at the end, give me your opinion about :

- Install SQL 2000 SP4 or SQL 2005 ?
- Install MSCS or a third party software, like Computer associates ?

Thanks in advance,



Relevant Pages

  • Re: Adp to asp web page
    ... of drunk retards that dont understand web development ... when I went into the connection box, it listed my server but in the drop ... Access ADP is merely front end app and IDE for SQL Server, ... ASP is old technology and different from ASP.NET. ...
  • Re: How to Set Datetime on SQL 2000 server
    ... the site on the new server still links to the same SQL ... The asp pages on this new server works fine with all date data. ... least pass language neutral datetime formats to SQL Server ... the desired format. ...
  • Re: Locked out of my own SQL Server???
    ... >back on the original server, it's trying to get onto SQL ... within my ASP ... >> app to use an applicationwide Connectionstring Variable ... >> Microsoft OLE DB Provider for SQL Server ...
  • Re: ASP page will not load
    ... >>> using ASP. ... Why do I get a 500 Internal Server error for all ... >>Internet Services Manager. ... >>Properties, and on the Home Directory tab, click the ...
  • Re: Ecommerce Server Requires Daily Reboot
    ... Sounds like you need a good ASP developer to go through ... SQL data caching schemes, to IIS settings, etc, etc, etc. ... a file cache on the web server. ... In order for customer to access webpage login, ...