Differences

This shows you the differences between two versions of the page.

--- computing:windows:mssql_install [2013/01/31 14:31]
gcooper
+++ computing:windows:mssql_install [2015/02/06 11:21] (current)
gcooper
@@ Line 1: / Line 1: @@
 ====== 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/
@@ Line 7: / Line 13: @@
 http://technet.microsoft.com/en-us/sqlserver/ff898410
-==== Install ====
+==== Installation ====
 :!: 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 (sqldb)
+  - Start downloading the latest MSSQL Service Pack
-  - Decide where to install to (E:)
+  - Add a local user to the MSSQL server
-  - Install Microsoft .NET 3.5 SP1 (Server Manager -> Roles -> Add Role -> Application Server -> .Net 3.5.1)
+    * **sqldb**
-  - Run the MSSQL setup
+  - Decide install location
-  - Run the "System Configuration Checker" and fix any errors
+    * **E:**
-  - Select "Installation" then "New installation or add features to an existing installation."
+  - Install Microsoft .NET 3.5 SP1
-  - Install the Setup Support files
+    * **Server Manager -> Roles -> Add Role -> Application Server -> .Net 3.5.1**
-  - On the "Setup Role" page choose "**SQL Server Feature Installation**"
+  - 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
+    * **Database Engine Services**
-    * Client Tools Connectivity
+    * **Client Tools Connectivity**
-    * Integration Services
+    * **Integration Services**
-    * Management Tools – Basic
+    * **Management Tools – Basic**
-    * Management Tools – Complete
+    * **Management Tools – Complete**
-  - ssdfad
+  - **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

Virtual Architects Support Wiki

User Tools

Site Tools

Differences

Page Tools