An 30 Apr 2004 07:33:58 -0700, sgrìobh
(E-Mail Removed) (Allan
Palmer):
> Hello,
>
> I'm getting ready to deploy a website on a Windows Server 2003 box.
> I've been looking around for ways to make this server as secure as
> possible, by settings in Windows Server 2003 and by 3rd party
> anti-virus and software firewall. The server will be running crystal
> reports enterprise 9, sql server 2000 and will be scaning emails for
> content. If any of you have any suggestions (aside from moving to a
> linux server, not an option
), it would be greatly appreciated.
>
> thanks,
> che
Make sure it's up to date on windows fixes.
Plan for some amount of down time to install new fixes as they are
released.
Run the MS vulnerability analysis tools and fix everything they point
up.
Download the guides to securing systems avaiklable on the MS website.
Use a decent firewall, and configure it properly. Block off all ports
your system doesn't need (what do you want ICMP for, for example - but
most firewalls will leave it open by default).
Put some gateway-oriented AV software on the gateway behind the
firewall (if you have one).
If you can afford the compute power to do it, put local firewall
software on the server as well as having a separate firewall - and use
it to specify which applications are allowed to access which ports.
Don't run SQL Server under "local system" - run it as a user, with
only the privileges it needs.
If you can fit your applications around it (this can be hard for
applications developed without considering this point), don't allow
SQL Server authentication - only allow windows authentication for
access to SQL server.
Don't give SQL users who don't need it access to xp-cmdshell.
Go through all the configuration options of all the components and set
safe values.
Use AV software that provides frequent signature file updates (at
least one of the most popular products provides only weekly updates,
which isn't helpful when many new viruses achieve their maximum
penetration within two days of release) and frequent engine updates.
Set your AV stuff to scan all updates to ilestore (not just email) and
to scan all newly inserted removable media.
A Windows server can be made pretty secure provided you are careful
how you set it up. The big problem is that the default settings are
not very secure (they used to be hopelesslu insecure, but things are
getting better, so you have to go through them all and fix that.
Don't even consider switching to Linux - look at the CERT record for
server vulnerabilities and the lengths of the windows between a
vulnerability being known and a fix being available if you don't
underastand that comment.
M.
[my real email address has no no in it]