http://technet.microsoft.com/en-us/sqlserver/ff898410

http://support.microsoft.com/kb/2527041

http://lonesysadmin.net/2011/10/06/how-to-install-microsoft-sql-server-2008-r2-for-vmware-vcenter-5/

http://technet.microsoft.com/en-us/sqlserver/ff898410

Firewall warnings are mostly important if accessing the server from other hosts, which is very common, but not universal.

1. Start downloading the latest MSSQL Service Pack
2. Add a local user to the MSSQL server
   • sqldb
3. Decide install location
   • E:
4. Install Microsoft .NET 3.5 SP1
   • Server Manager → Roles → Add Role → Application Server → .Net 3.5.1
5. Run the MSSQL setup
6. Run the “Planning → System Configuration Checker” and fix any errors
7. Select “Installation → New installation or add features to an existing installation”
8. Install the Setup Support files
9. On the “Setup Role” page choose
   • SQL Server Feature Installation
10. On the “Feature Selection” page, select:
    • Database Engine Services
    • Client Tools Connectivity
    • Integration Services
    • Management Tools – Basic
    • Management Tools – Complete
11. Change the Shared Feature directories from C: to E: with the same path
12. On the “Instance Configuration” page:
    • Choose the default instance and use the default instance ID (MSSQLSERVER)
    • Change the instance root directory from C: to E: with the same path
13. 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”
    • Set “SQL Server Database Engine” is also set to Automatic
    • Verify that “SQL Server Browser” is set to Disabled and has the account name set to “NT AUTHORITY\LOCAL SERVICE”
14. On the “Database Engine Configuration” page:
    • “Account Provisioning” tab
      • Choose Mixed Mode (SQL Server authentication and Windows authentication)
      • Set a password for the “sa” account
      • Under “Specify SQL Server administrators”, add “Administrator” (Add Current User)
    • “Data Directories” tab
      • Change all the C:'s to E:'s
15. Finish the installation
16. Install the latest SQL Server Service Pack
17. Run Windows Update

1. Run “Microsoft SQL Server Management Studio” and log in as the “sa” user
2. Adjust “Maximum Server Memory (MB)”:
   • Right-click SQL Server object → Properties → Memory
   • This page has a nice chart: http://www.sqlservercentral.com/blogs/glennberry/2009/10/29/suggested-max-memory-settings-for-sql-server-2005_2F00_2008/

The above installation procedure does NOT install Reporting Services. If your application requires Reporting Services, you must check an additional box on the “Feature Selection” page.

• Maxwell Pro Contractor MX

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/eb98e589-e147-4168-9da0-4a0527b3a6fa

Follow these steps to uninstall previous installed SQL Server completely and then try to reinstall SQL Server 2008:

1. Remove all SQL Server components from 'Programs and Features'
2. Backup the registry
3. Delete the following keys in regedit:

   • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

   • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer

4. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall and delete all the sub-keys referencing SQL Server
5. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server
6. Rename all the SQL Server folders in the computer
7. Reboot the machine
8. Install SQL Server 2008 under an administrator account again