BEST PRACTICES FOR INSTALLING SQL SERVER

2008 R2

Sanjeewa JayawickramaMBCS, MCTSDBA - eCollege Lanka

Recommendations For Installing

Use NTFS file system Do not install on a compressed drive Do not install SQL Server on a Domain

Controller Requires setup administrative privileges

Software Requirements

.Net Framework 3.5 SP1 Windows Installer 4.5 or later Internet Explorer 6 SP1 PowerShell Visual Studio 2008 SP1 prior to run SQL

Server setup

Hardware Requirements At least 3.6 GB Hard Disk

Memory Min Recommended Datacenter 1 GB 4 GB or more Entrprise 1 GB 4 GB or more Standard 1 GB 4 GB or more

CPU 2 GHz or Faster

Supported Operating Systems. All Edition

Windows Server 2008 Standard or higher Windows Server 2003 Standard SP2 or higher

Developer and Express Windows XP Professional SP2 or higher Windows Vista Home Basic or higher

1024 x 768 video resolution.

Lets Install…

Complete

View the Setup summary.

Reference

• http://www.networkworld.com/subnets/microsoft/121908-ch1-ms-sql-server2008.html?page=3

• http://sharepointgeorge.com/2012/installing-sql-server-powerpivot-sharepointstep-step-guide/

• http://msdn.microsoft.com/en-us/library/aa174516(v=sql.80).aspx

• http://msdn.microsoft.com/en-us/library/ms143432(v=sql.100).aspx

• http://msdn.microsoft.com/en-us/library/ms143506(SQL.105).aspx

• \\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120619_170743\SystemConfigurationCheck_Report.htm

Q & A

What are the reasons to have multiple SQL Server instances?

To have different environments for QA testing or development

To support multiple service packs or patch levels To allow access for only set of databases To support multiple SQL Server versions

Q & A

Why SSAS & SSRS are under Instance feature and SSIS is under Shared component? Integration Service feature integrates data

from different sources. Analysis & Reporting Services are separate

services on each Instance and facilitate use different configuration.

Q & A

What are the “unchangeable” configurations of SQL Server? Collation Instance Name

Thank you