SQL Server and MySQL Notes: SQL Server 2011 AKA Denali Step By Step Installation

SQL Server 2011 AKA Denali
As we all aware about that, Microsoft has released SQL Server 2011 CTP1. CTP stands for Community Technology Preview and it is a beta version of upcoming release.

Minimum Software and Hardware Requirement

We can install Denali on both the file system formats (FAT32 and NTFS) but the Microsoft recommends NTFS file format.

Your Operating system must have "no-reboot" package installed prior to installing SQL Server 2011. By default it is included in Windows 7 SP1 and Windows Server 2008 R2. For the other OS you can download No Reboot package from http://support.microsoft.com/kb/982526 link.

.NET Framework 4.0

Virtualization is supported using Microsoft's Hyper-V technology.

At least 3.4GB free disk space

At least 2GB RAM

Windows PowerShell 2.0 is a pre-requisite

SQL Server 2011 AKA Denali Installation Steps
[caption id="attachment_1115" align="aligncenter" width="614" caption="Step 1 : Go to Setup folder and click on Setup.exe"]

[/caption]

[caption id="attachment_1116" align="aligncenter" width="614" caption="Step 2: Go to Installation Page and Select Stand Alone Installation"]

[/caption]

[caption id="attachment_1117" align="aligncenter" width="614" caption="Step 3: Setup will validate the the OS for minimut requirement. You must have noReboot Package installed."]

[/caption]

[caption id="attachment_1118" align="aligncenter" width="614" caption="Step 4: Setup will again the check the rules for example Power Shell, Firewall, .Net Framework Security etc"]

[/caption]

[caption id="attachment_1119" align="aligncenter" width="614" caption="Step 5: Give you an option of new installation or add features to existing instance."]

[/caption]

[caption id="attachment_1120" align="aligncenter" width="614" caption="Step 6: Give you an option to Select edition"]

[/caption]

[caption id="attachment_1121" align="aligncenter" width="614" caption="Step 7: Accept Agreement Screen"]

[/caption]

[caption id="attachment_1122" align="aligncenter" width="614" caption="Step 8: Give you an option to select required feature"]

[/caption]

[caption id="attachment_1123" align="aligncenter" width="614" caption="Step 9: Give you an option to select the instance level features"]

[/caption]

[caption id="attachment_1124" align="aligncenter" width="614" caption="Step 10: Again validate the server for the selected features"]

[/caption]

[caption id="attachment_1125" align="aligncenter" width="614" caption="Step 11: Gives you an option to select the named instance/default instance"]

[/caption]

[caption id="attachment_1126" align="aligncenter" width="614" caption="Step 12: Will show your the disk space required for the selected features"]

[/caption]

[caption id="attachment_1127" align="aligncenter" width="614" caption="Step 13: Specify the service accounts"]

[/caption]

[caption id="attachment_1128" align="aligncenter" width="614" caption="Step 14: Specify the collation"]

[/caption]

[caption id="attachment_1129" align="aligncenter" width="614" caption="Step 15: Specify the Authentication Mode, Data Directories and File Stream"]