User Tools
computing:windows:mssql_install
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
computing:windows:mssql_install [2013/01/31 15:14] gcooper |
computing:windows:mssql_install [2015/02/06 11:21] (current) gcooper |
||
|---|---|---|---|
| Line 13: | Line 13: | ||
| http:// | http:// | ||
| - | ==== 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. | ||
| 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 " | + | - Run the "**Planning -> System Configuration Checker**" |
| - | - Select " | + | - Select " |
| - Install the **Setup Support files** | - Install the **Setup Support files** | ||
| - On the "Setup Role" page choose | - On the "Setup Role" page choose | ||
| Line 56: | Line 56: | ||
| - **Install the latest SQL Server Service Pack** | - **Install the latest SQL Server Service Pack** | ||
| - **Run Windows Update** | - **Run Windows Update** | ||
| + | |||
| + | ==== Initial Configuration ==== | ||
| + | |||
| + | - Run " | ||
| + | - Adjust " | ||
| + | * Right-click SQL Server object -> Properties -> Memory | ||
| + | * This page has a nice chart: http:// | ||
| + | |||
| + | ==== 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. | ||
| + | |||
| + | === Apps Requiring Reporting Services === | ||
| + | |||
| + | * Maxwell Pro Contractor MX | ||
| + | |||
| + | ====== Complete Uninstall ====== | ||
| + | |||
| + | http:// | ||
| + | |||
| + | Follow these steps to uninstall previous installed SQL Server completely and then try to reinstall SQL Server 2008: | ||
| + | |||
| + | - Remove all SQL Server components from ' | ||
| + | - Backup the registry | ||
| + | - Delete the following keys in regedit: | ||
| + | * < | ||
| + | * < | ||
| + | - 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.1359670447.txt.gz · Last modified: 2013/01/31 15:14 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
