This is an old revision of the document!
Installing Microsoft SQL Server
SQL Server 2008 R2
Install
Firewall warnings are mostly important if accessing the server from other hosts, which is very common, but not universal.
Add a local user to the MSSQL server
Decide install location
Install Microsoft .NET 3.5 SP1
Run the MSSQL setup
Run the “System Configuration Checker” and fix any errors
Select “Installation” then “New installation or add features to an existing installation”
Install the Setup Support files
On the “Setup Role” page choose
On the “Feature Selection” page, select:
Change the Shared Feature directories from C: to E: with the same path
On the “Instance Configuration” page:
On the “Server Configuration” page:
Select “Use the same account for all SQL Server services”
Enter the local username and password you created above (sqldb)
Set “SQL Server Agent to “Automatic”
Ensure the “SQL Server Database Engine” is also set to Automatic