User Tools

Site Tools


computing:windows:mssql_install

This is an old revision of the document!


Installing Microsoft SQL Server

SQL Server 2008 R2

Install

:!: Firewall warnings are mostly important if accessing the server from other hosts, which is very common, but not universal.

  1. Add a local user to the MSSQL server
    • sqldb
  2. Decide install location
    • E:
  3. Install Microsoft .NET 3.5 SP1
    • Server Manager → Roles → Add Role → Application Server → .Net 3.5.1
  4. Run the MSSQL setup
  5. Run the “System Configuration Checker” and fix any errors
  6. Select “Installation” then “New installation or add features to an existing installation
  7. Install the Setup Support files
  8. On the “Setup Role” page choose
    • SQL Server Feature Installation
  9. On the “Feature Selection” page, select:
    • Database Engine Services
    • Client Tools Connectivity
    • Integration Services
    • Management Tools – Basic
    • Management Tools – Complete
  10. Change the Shared Feature directories from C: to E: with the same path
  11. 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
  12. 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”
computing/windows/mssql_install.1359669212.txt.gz · Last modified: 2013/01/31 14:53 by gcooper