|||

Installing Microsoft SQL 2016, and Management Studio

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 Deploy VMware vCenter Appliance (VCSA) Intel NUC Lab Hosts Hardware Setup
Latest posts Update macOS with an all in one alias Mac App Store Command Line Interface Update macOS with softwareupdate command Markdown Crash Course Video What’s New with Fusion and Workstation [HCP1833] File IO in Python Overview of vSphere 7 Video What is ISO? Migrating Website HTML details Tag Microsoft RD Client iOS App Create VMware ESXi USB Install Media Intel NUC Lab Hosts Hardware Setup Installing Microsoft SQL 2016, and Management Studio Deploy VMware vCenter Appliance (VCSA) Installing the First Two Domain Controllers in the VMware ESXi 6.7 Lab Environment 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 Create a Windows 10 Sandbox VM on VMware Workstation 14 RSA Conference 2018 Installing VMware Workstation 14 on Windows 10 VMware vExpert 2018 Announcement, Great News