Best Security Template for a Member Server level SQL server install

From: Monty (montysl_at_nospam.hotmail.com)
Date: 07/30/04 

Date: Fri, 30 Jul 2004 10:37:57 -0500

This does not seem like rocket science but I can't find a recommendation
from MS on which uplevel (from defaults) Security Template (file server,
infrastructure server, etc.) is the best baseline starting point for a SQL
install on a W2K3 AD. I realize that mods will be necessary no matter but
since there are 700+ settings having a head start seems like a good thing. I
have created the OU specifically for the SQL server and just need to
configure it's GP including IPSec. I have implemented most of the suggested
Security settings to the install of SQL itself (see prior post).

Any suggestions?

Thanks

Relevant Pages

  • Re: WwK3 cluster + MSSQL sp3a upg.
    ... you need to get SP3a on your SQL for it to be supported on Windows ... security template that does not lock it down as much. ... MVP - Windows Server - Clustering ...
    (microsoft.public.sqlserver.clustering)
  • Re: Weird Problem
    ... That's not a SQL Server error. ... > updates a database running on a sql 2000 server.(The web site was ... > I tried to lower the security settings and even removed the enhanced ...
    (microsoft.public.sqlserver.server)
  • File access issues at 17:00
    ... I am running a Windows 2003 Server Standard. ... with a small accounting database ... using SQL 2000. ... do not want to take off all the security settings in place. ...
    (microsoft.public.windows.file_system)
  • Re: ActiveX Cannot Create Object
    ... > The Box is a dedicated DB Server Running on Window 2003 Server. ... Sql ... > 2000 Enterprise Edition, With MS Office and Outlook installed. ... SP1 changed some security settings for DCOM & MSDTC which caused some ...
    (microsoft.public.sqlserver.dts)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)