SQL Server Installation Considerations

Before taking steps to secure your database server, know the additional components that are present on a Windows 2000 Server after SQL Server is installed.

What Does SQL Server Install?

When you install SQL Server, a number of Windows services are installed in addition to program and data files. By default, program and data files are located in the \Program Files\Microsoft SQL Server\ directory. Table 18.1 shows the services and folders that are created.

Table 18.1: SQL Server Installation Defaults

Item	Details
Services	MSSQLSERVER MSSQLServerADHelper Microsoft Search SQLSERVERAGENT
Folders	\program files\Microsoft SQL Server\ mssql \binn (program files) \program files\Microsoft SQL Server\mssql\data (data files including .mdf, .log, and .ndf) \program files\Microsoft SQL Server\80\tools (shared tools/books online) \program files\Microsoft SQL Server\mssql\logs (error logs) \program files\Microsoft SQL Server\mssql\backup (backup files) \program files\Microsoft SQL Server\mssql\jobs (temp job output files) For named instances, the instance name is used in the file path : \program files\Microsoft SQL Server\MSSQL$InstanceName\binn \program files\Microsoft SQL Server\MSSQL$InstanceName\data