Re: Web App Security Model.



"Lincoln De Kalb" <lincoln.dekalb@xxxxxxxxxx> wrote in message
news:eq%23LCZ8WHHA.4624@xxxxxxxxxxxxxxxxxxxxxxx
Thanks for the information.

So basically just follow standard procedure for locking down IIS /
Webserver etc and I should be OK.


OK if the web application itself is well designed / implemented and the
SQL permissions are correctly restrictive (so worse case the allowed
database is extent of what is at risk on the SQL server). Also, if Windows
integrated domain account is used for the SQL access (i.e. trusted
connection)
then if the web app can be exploited then potentially anything in the domain
is at risk to the extent that the domain account has grants (ex. if it is in
Domain Users, if there are grants to Authenticated Users, etc.) and that
the network connection between the IIS box and the SQL box can get to
other locations (such as certainly to the DCs).
Again, very much depends on the quality of the web application(s).


Because of the authentication needed I'll be in the Active Directory
domain. The app will be connecting to a SQL 2005 server in the domain. I'm
thinking about putting it in it's own sub-domain but the additional costs
of servers for DC's might be prohibitive.


Not just high cost, but it probably would not provide much gain.

Thanks again.

no problem


"Roger Abell [MVP]" <mvpNoSpam@xxxxxxx> wrote in message
news:%23vX9lF0WHHA.4860@xxxxxxxxxxxxxxxxxxxxxxx
Some would say it is better to have those machines, latched down
to tcp 80, 443 as you say, sitting outside compared to inside in the
circumstance you describe.
You have not indicated how the machines are with regard to AD,
any domains, etc. database accesses, backup access, etc..
If these machines are standalone the threats posed by them are
significantly different from if not, obviously, but much also depends
on how inconvenient administrative / backup / etc access is if they
are standalone (generally more convenient is more risk)

Anyway, very very much depends on the quality of the aspx
applications / implementation and whether their design has
been done with security (of your whole infrastructure) in mind.

There is some guidance at
http://www.microsoft.com/technet/security/guidance/default.mspx
and IIRC more in msdn2

Roger
"Lincoln De Kalb" <lincoln.dekalb@xxxxxxxxxx> wrote in message
news:e3jok4uWHHA.392@xxxxxxxxxxxxxxxxxxxxxxx
Hey all,

I'm not really looking for an answer, i'm looking for pointers on where
to look.

My company wants to have a few Windows Servers running web app's (ASPX
based primarily) available externally. They will be behind a firewall
with strict rules (like 80, 8080, 443) etc....

For the time being there wont be a Firewall between the servers and the
primary network, so we aren't in a DMZ type environment.

I'm struggling to find any information on technet, windowssecurity.com,
techrepublic etc etc. on best practices or thigns to consider for this
type of environment. I really wouldn't have thought it that different to
what most people would set up.

So if you can point me in the right direction, that would be superb. Or
maybe i'm missing something so fundamental that it's a no brainer and
hence no documentation.

Ta heaps.
Lincoln







.



Relevant Pages

  • Re: sql 2005 active/passive cluster options
    ... that is storing data on a seperate SQL 2005 Standard box. ... SQL server had an hardware fault causing application downtime for ... their product is an active/passive sql cluster. ... terms of active/passive failover I need two identical servers (since ...
    (microsoft.public.sqlserver.clustering)
  • RE: permissions compatible with pre-Win2000 servers
    ... Based on your reply, the NT machine which running SQL 7 is not a PDC, BDC, ... With regards to the anonymouse connection to SQL, ... >Our concern is for our NT4 servers that are dedicated to running SQL7 ...
    (microsoft.public.windows.server.migration)
  • Re: Performance Monitor / Database Storage using ODBC
    ... This solution would be just working temporarily (a few servers), ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: Web App Security Model.
    ... If these machines are standalone the threats posed by them are ... My company wants to have a few Windows Servers running web app's (ASPX ... For the time being there wont be a Firewall between the servers and the ... so we aren't in a DMZ type environment. ...
    (microsoft.public.security)
  • Re: SQL cluster search problems - this may help
    ... Given that the problem was caused by DLL differences in an SQL installation, ... standalone WSS users. ... Although I don't have a standalone installation of WSS, ...
    (microsoft.public.sharepoint.portalserver)