LAB – Install SQL 2008R2

My personal minimalistic notes of a SQL 2008R2 installation. System Requirements Hardware Settings Memory – 512 MB Dynamic Processor – 2 Virtual processors Hard Drive – (IDE) System 40 GB, (SCSI) Data 500 GB – Dynamically Expand Prerequisite Software Operating System Windows 2008 R2 Standard Accounts Create Domain User “sasqlagent” – SQL Server Agent Create Domain Administrator “sasqldatabaseengine” – SQL Server Database Engine (To register SQL SPN) Create Domain User “sasqlreporting” – SQL Server Reporting Services Install IIS Windows Server Internet Information Services (IIS) 7 – Add Role – Web Server (IIS) Add Role Services – ASP.NET .NET Extensibility ISAPI Extensions ISAPI Filters IIS 6 Metabase Compatibility IIS 6 WMI ...