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/02/05 13:18]
gcooper 		computing:windows:mssql_install [2015/02/06 11:21] (current)
gcooper
Line 25: 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 63: Line 63:
     * Right-click SQL Server object -> Properties -> Memory     * 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/     * 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 ==== ==== Reporting Services ====
Line 81: Line 88:
   - Backup the registry   - Backup the registry
   - Delete the following keys in regedit:    - Delete the following keys in regedit: 
-    * --HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server  +    * <file>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server</file>  
-    * --HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer+    * <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\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   - Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server
computing/windows/mssql_install.1360095500.txt.gz · Last modified: 2013/02/05 13:18 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