Virtual Architects Support Wiki

User Tools

Site Tools

You are here: start » computing » windows » mssql_install
Trace: • hyper-v-cluster
computing:windows:mssql_install

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
computing:windows:mssql_install [2013/01/31 14:36]
gcooper 		computing:windows:mssql_install [2015/02/06 11:21] (current)
gcooper
Line 1: Line 1:
 ====== Installing Microsoft SQL Server ====== ====== Installing Microsoft SQL Server ======
 +
 +===== SQL Server 2012 =====
 +
 +http://technet.microsoft.com/en-us/sqlserver/ff898410
  
 ===== SQL Server 2008 R2 ===== ===== 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://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 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. :!: 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   - Add a local user to the MSSQL server
     * **sqldb**     * **sqldb**
Line 18: Line 25:
     * **Server Manager -> Roles -> Add Role -> Application Server -> .Net 3.5.1**     * **Server Manager -> Roles -> Add Role -> Application Server -> .Net 3.5.1**
   - Run the **MSSQL setup**   - Run the **MSSQL setup**
-  - Run the "**System Configuration Checker**" and fix any errors +  - Run the "**Planning -> System Configuration Checker**" and fix any errors 
-  - Select "**Installation**" then "**New installation or add features to an existing installation**"+  - Select "**Installation -> New installation or add features to an existing installation**"
   - Install the **Setup Support files**   - Install the **Setup Support files**
   - On the "Setup Role" page choose   - On the "Setup Role" page choose
Line 30: Line 37:
     * **Management Tools – Complete**     * **Management Tools – Complete**
   - **Change the Shared Feature directories from C: to E:** with the same path   - **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
computing/windows/mssql_install.1359668198.txt.gz · Last modified: 2013/01/31 14:36 by gcooper

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki