SQL Server 2014, Part 2 of 9: Installing
Interactive

SQL Server 2014, Part 2 of 9: Installing

BizLibrary
Updated Feb 04, 2020

So your company has decided to purchase or upgrade to SQL Server 2014, so now what? This course will cover how to prepare for a SQL Server 2014 installation. It will help you to understand what is involved in upgrading an earlier version of SQL Server to SQL Server 2014. See how to install a default instance of SQL Server 2014 and find out how to configure the server after the installation.


Lesson 1:

  • Requirements
  • Domain Controller
  • Other Considerations
  • Network Software Requirements
  • Setting Up the Service Accounts
  • Multiple Instances
  • Multiple Instance Scenario
  • Using Named Instances
  • Instance Components.

Lesson 2:

  • Considerations
  • Upgrade Advisor
  • Demo: Upgrading
  • Demo: Upgrade Advisor
  • Demo: Resolving Problems.

Lesson 3:

  • SQL Server 2014 Installation
  • Demo: Installing SQL Server
  • Demo: Checking for Updates
  • Demo: Setup Role
  • Demo: Feature Selection
  • Demo: Installation Rules
  • Demo: Server Configuration
  • Demo: Database Engine Config
  • Demo: Error Reporting
  • Demo: Installing.

Lesson 4:

  • SQL Server Configuration
  • Demo: Configuration Manager
  • Demo: Server Configuration
  • Demo: Server Properties
  • Demo: General Settings
  • Demo: Memory Page
  • Demo: Server Processors
  • Demo: Security
  • Demo: Connections
  • Demo: Database Settings
  • Demo: Advanced Page.
;