do we need extra server to run web applications?

[Alex]

Our company wants to run web based application
in folowing way.

Browser --> WebServer -->Sql Server

Sql server is part part of corporation domain and has about 25 more databases

Should we dedicate extra SQL server to run Web apps , or it would be safe to run web apps on corporation Sql Server?
or
If any one can point on links on this subject?.
Thank you

[mmwops]

Hi Alex,

This is complex, although you might want to keep it simple.
First you have to define the security policy, but it is strongly discouraged to run a content server on a computer that is visible on the public network.
Secondly you might want to have a 24/7 environment which calls for load balancing webservers and clustered SQL servers.
Anyhow there are some very good whitepapers on the microsoft site, search for High Availability (solutions). Even if you don't need 24/7 operation, they contain valuable info on the setup of web/content server environments.



------------
Alex at 2/5/2002 3:01:01 PM

Our company wants to run web based application
in folowing way.

Browser --> WebServer -->Sql Server

Sql server is part part of corporation domain and has about 25 more databases

Should we dedicate extra SQL server to run Web apps , or it would be safe to run web apps on corporation Sql Server?
or
If any one can point on links on this subject?.
Thank you