====== Installing Microsoft SQL Server ======

===== SQL Server 2012 =====

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

===== SQL Server 2008 R2 =====

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

==== Installation ====

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

  - Start downloading the latest MSSQL Service Pack
  - Add a local user to the MSSQL server
    * **sqldb**
  - Decide install location
    * **E:**
  - Install Microsoft .NET 3.5 SP1
    * **Server Manager -> Roles -> Add Role -> Application Server -> .Net 3.5.1**
  - Run the **MSSQL setup**
  - Run the "**Planning -> System Configuration Checker**" and fix any errors
  - Select "**Installation -> New installation or add features to an existing installation**"
  - Install the **Setup Support files**
  - On the "Setup Role" page choose
    * **SQL Server Feature Installation**
  - On the "Feature Selection" page, select:
    * **Database Engine Services**
    * **Client Tools Connectivity**
    * **Integration Services**
    * **Management Tools – Basic**
    * **Management Tools – Complete**
  - **Change the Shared Feature directories from C: to E:** with the same path
  - 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
  - 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"
  - 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**
  - **Finish the installation**
  - **Install the latest SQL Server Service Pack**
  - **Run Windows Update**

==== Initial Configuration ====

  - Run "Microsoft SQL Server Management Studio" and log in as the "sa" user
  - 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/

==== Firewall ====

^ Port to Allow ^ Description                                       ^
|1433 TCP       | Default Instance                                  |
|1434 UDP       | Browser Service                                   |
|80 TCP         | HTTP Access to ReportServer                       |

==== Reporting Services ====

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.

=== Apps Requiring Reporting Services ===

  * Maxwell Pro Contractor MX

====== Complete Uninstall ======

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:

  - Remove all SQL Server components from 'Programs and Features'
  - Backup the registry
  - Delete the following keys in regedit: 
    * <file>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server</file> 
    * <file>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer</file>
  - Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall and delete all the sub-keys referencing SQL Server
  - Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server
  - Rename all the SQL Server folders in the computer
  - Reboot the machine
  - Install SQL Server 2008 under an administrator account again