SQL Server – Installation – v2019

Background

Needing to install MS SQL Server v2019 so that I can start evaluating it.

Artifacts

Please go here to download SQL Server 2019 :-

  1. Community Technology Preview ( CTP )
    • SQL Server 2019 – CTP
      • SQL Server 2019 CTP
        CTP

 

Installation

Outline

Install Steps

  1. Product Key
    • Choices are
      • Specify a Free Edition
      • Enter the Product Key
    • Accept default of Free Edition ( Evaluation )
  2. License Terms
    • Accept the License Terms
  3. Install Setup Files
    • The files that will be used for the setup are themselves installed
  4. Feature Selection
    • Please review features
    • And, select the features you want
      • Database Engine
        • We want the Database Engine
          • Please specify the drive and folder where the database engines files will be installed
          • By default the system drive ( C: ) will be targeted
  5. Instance Configuration
    • Choices
      • Choose Instance
        • Default
        • Named Instance
      • If a default instance is not already installed, consider accepting the default choice
      • Else, if another instance already exists, please specify a name to assign the instance you are installing
    • Our choice
      • We have a default instance installed on same box
      • We entered a new name
  6. Server Configuration
    • Choices
      • Review Services
        • Service Account Name
        • Startup Type
    • Our choice
      • We chose go with the default Service Account Names
  7. Database Configuration
    • TempDB
      • Data files
        • Drive and Folder to locate TempDB Data Files
        • Initial Size
        • File Growth
        • Based on number of CPU Cores
          • Choose # of TempDB files
      • Log Files
        • Drive and Folder to locate TempDB Log Files
  8. Analysis Services Configuration
    • Tab :- Server Configuration
      • Please add the accounts ( Active Directory and Local Accounts that should have access )
  9. Ready To Install
  10. Installation Progress
  11. Complete
    • Restart Computer
      • As there are pending file operations, please advance towards completing the install, gracefully exiting the Install application,  and restart your computer

Server Network Configuration

Post Installation and Computer Reboot Steps:

  1. Restarted Computer
  2. Launch Server Network Configuration
  3. Adjust Instance Network Configuration

Screenshots

Install Steps

Product Key

productKey.01.20190411.1126AM.PNG

License Terms

licenseTerms.01.20190411.1127AM.PNG

Install Setup Files

installSetupFiles.01.20190411.1127AM.PNG

Feature Selection

Initial

FeatureSelection.01.20190411.1128AM.PNG

Customize

FeatureSelection.02.20190411.1130AM.PNG

Instance Configuration

Initial

instanceConfiguration.01.20190411.1131AM.PNG

Revise

instanceConfiguration.02.20190411.1132AM.PNG

 

Server Configuration

Initial

serverConfiguration.01.20190411.1134AM.PNG

Revise

serverConfiguration.02.20190411.1136AM.PNG

Database Configuration

Initial

DatabaseEngineConfiguration.01.20190411.1137AM.PNG

Revise
Revise – Tab – TempDB

DatabaseEngineConfiguration.Tab.TempDBFiles.01.20190411.1138AM.PNG

Analysis Services Configuration

Revise

AnalysisServicesConfiguration.01.20190411.1140AM.PNG

Ready to Install

Installation Progress

installProgress.01.20190411.1146AM.PNG

Complete

Restart Computer

ComputerRestartRequired.01.20190411.1205PM.PNG

Complete
Complete.01.20190411.1206PM.PNG

Sql Server Configuration Manager

SQL Server Network Configuration

Protocols
Protocol – TCP/IP Properties

SQLServerConfigurationManager.01.20190412.0117PM.PNG

 

Summary

Considerations

  1. Upgrade Path
    • Edition – Evaluation
      • You can advance a previous version to v2019 only if the current version is Evaluation
  2. Post Upgrade
    • Review Services
      • Please stop and disable previous services
    • Amend Network Ports
      • Only one service can use a network port at a time
      • Review each serview and amend the Network Port it is using

 

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s