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 06:21]
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 71: Line 78:
  
   * Maxwell Pro Contractor MX   * 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.1360070473.txt.gz · Last modified: 2013/02/05 06:21 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