|||

0089-installng_microsoft_sql_2016

Screenshot of MS SQL installing

SQL Environment

I’m installing MS SQL 2016 in this lab. Things like WSUS, will be moved here after their default installs, to see how those migration processes work.

Later, these databases will be moved to a clustered environment, to explore that migration path, as well.

Another Building Block Down!

Mount the ISO, and Install

Prepare a Windows 2016 VM, patched current, network configured, and joined to the domain.

Screenshot of Server Manager Console

Download, and mount, the SQL ISO from Microsoft Downloads

Screenshot of MS SQL installing

Double click on the Mounted Drive, and begin the installation.

Screenshot of MS SQL installing

The initial Planning section has installation documentation, a system configuration checker, as well as an Installation Advisor to identify possible issues that need to be resolved.

Screenshot of MS SQL installing

Click on the Installation section on the left. Select the installation type, in this lab, I’m selecting a stand-alone installation.

Screenshot of MS SQL installing

Select Evaluation, or enter your license key. Click Next.

Screenshot of MS SQL installing

Accept the EULA, and click Next.

Screenshot of MS SQL installing

Select Check for Updates, and click Next.

Screenshot of MS SQL installing

It’s scanning for updates.

Screenshot of MS SQL installing

Click Next.

Screenshot of MS SQL installing

Select the features to be installed, and click Next.

Screenshot of MS SQL installing

Name the instance, or accept the default, and click Next.

Screenshot of MS SQL installing

Click Next

Screenshot of MS SQL installing

Choose Mixed Mode, assign SA password, and specify administrators.

Screenshot of MS SQL installing

Click Next

Screenshot of MS SQL installing

Click Next

Screenshot of MS SQL installing

Click Install

Screenshot of MS SQL installing

Installing

Screenshot of MS SQL installing

Click Close, when complete.

Screenshot of MS SQL installing

Install Management Studio Select Install SQL Server Management Tools.

Screenshot of MS SQL installing

Click Install

Screenshot of MS SQL installing

Installing

Screenshot of MS SQL installing

Screenshot of MS SQL installing

Screenshot of MS SQL installing

Screenshot of MS SQL installing

Click Restart

Screenshot of MS SQL installing

SQL, and the Management Tools should now be listed on the Start Menu.

Screenshot of MS SQL installing

Up next Installing the First Two Domain Controllers in the VMware ESXi 6.7 Lab Environment Intel NUC Lab Hosts Hardware Setup
Latest posts 0104-change-synology-password-cli 0105-free-git-ebook 0103-using-brew-bundle-to-backup-and-restore-mac-app-store-and-brew-apps Update macOS with an all in one alias Mac App Store Command Line Interface 0100-macos-softwareupdate-cli Markdown Crash Course Video What’s New with Fusion and Workstation [HCP1833] File IO in Python Overview of vSphere 7 Video 0095-what_is_iso Migrating Website HTML details Tag Microsoft RD Client iOS App 0091-create_vmware_esxi_usb_install_media Intel NUC Lab Hosts Hardware Setup 0089-installng_microsoft_sql_2016 Installing the First Two Domain Controllers in the VMware ESXi 6.7 Lab Environment 0088-deploy_vcsa_in_lab Macchanger Utility, and Usage Install a Kali Linux VM in a VMware ESXi 6.7 Environment Install Ubuntu 18.04 Virtual Machine in a VMware ESXi 6.7 Environment Install xRDP on Ubuntu 18.04 Install Chromium on Ubuntu 18.04 Install OpenSSH on Ubuntu 18.04 Install VMware Workstation 14 on Ubuntu 18.04 Nested ESXi server Laboratorium Rattus The Animal Within Who is Veeam? RSAC OnDemand Videos 0075-create_win10_sandbox_vm