User Tools

Site Tools


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:23]
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 ====
computing/windows/mssql_install.1360095804.txt.gz · Last modified: 2013/02/05 13:23 by gcooper