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 Compatibility
Static Content (Default)
Default Document (Default)
Directory Browsing (Default)
HTTP Errors (Default)
Request Filtering (Default)
Install SQL
Choose defaults unless told otherwise
Click “Install or run program from your media”
Automatic prerequisite install
.NET Framework 3.5 SP1
SQL Server Native Client
SQL Server Setup support files
Click Installation on the left and select “New Installation or Add Features to an existing installation”
Choose defaults unless told otherwise
Ignore Firewall warning
SQL Server Feature Installation
Database Engine Services
Reporting Services (Only when reporting with SCOM will be used)
Client Tools Connectivity
Management Tools – Basic
Management Tools – Complete
Change directory locations to “D”
Instance Configuration
Named Instance – SCVMM2008R2
Instance root directory – D:\SQLData
Server Configuration
SQL Server Agent – “sasqlagent” – Automatic
SQL Server Database Engine – “sasqldatabaseengine”
SQL Server Reporting Services – “sasqlreporting”
SQL Server Browser – NT AUTHORITY\LOCAL SYSTEM
Database Engine Configuration
Account Provisioning
Add Current User
Add … – Domain Admins
Ready to Install
Installed
ConnectSQL Server Management Studio
Server name – localhost\scvmm2008r2 or mysqlhost.domain.name\scvmm2008r2
Set Security
Firewall Rules (fw.msc)
Inbound Rule – TCP 1433, Domain, “Allow SQL 1433 Inbound”
Inbound Rule – TCP 445, Domain, “Allow SCVMM Population”
Change AD Permisions – “sasqldatabaseengine” – Add “Domain Users” and Remove “Domain Admins”

Leave a Reply

  

  

  

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.