.

Numbers Represent Hour's

.

References: http://msdn.microsoft.com/en-us/library/bb543165.aspx

.

References: http://msdn.microsoft.com/en-us/library/bb543165.aspx

.

MS SQL Server - Security & ProtectionSQL Server 2008SQL Server 2005SQL Server 2000/7.0Total In Hours

.

Security And RequirementsServer AccountsAD - People (DBAs)AD - AccountsAD - Services AccountsServer AccountsAD - PeopleAD_AccountsAD - Services AccountsServer AccountsAD - PeopleAD_AccountsAD - Services Accounts

.

PHASE I

.

General Security & Protection Best Practices2 [1]0.50.50.530.50.50.520.20.20.210.6

.

Pre-Installation Setup

.

Installation20.40.40.420.20.20.20.50.50.50.57.8

.

Database Engine410.5120.20.20.20.70.50.50.511.3

.

Analysis Services - MultiDimensional Data40.50.50.530.50.50.520.50.50.513.5

.

Analysis Services - Data Mining41113111211118

.

Integration Services31122111110.50.515

.

Replication210.30.520.30.30.510.50.50.59.4

.

Reporting Services20.51110.50.50.510.50.50.59.5

.

Service Broker210.50.520.50.50.510.50.50.510

.

PHASE IITotal Hours For Phase 1105.1 [2]

.

SQL Server Integration with Active Directory

.

[1] City of Miami: Pre Installation Security *Physical Security *Have a Firewall Between the Server and the Internet *Isolate Services-this reduces the implications of a compromise system *Use Separate Account for separate services, look at: http://msdn.microsoft.com/en-us/library/ms143504.aspx
[2] City of Miami: Around 13 Days to over view and Figure account the best practice for each service and Make a step by step to secure each one.