Getting Started with SQL Server 2017 - Installation

Introduction

SQL Server 2017 has not been officially released yet, but you can start evaluating it with the Community Technical Preview (CTP).  This post will describe how to download and install it.

Download

Before starting the SQL Server installation process it is a good idea to close any other programs, so the install is not competing with other programs.  Also, you will likely need to reboot at the end of the installation anyway.

To get started, head over to https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2017-ctp/.  You will then need sign in with your Windows Live account.  Once you are signed in, you will also need to register and set your communications preferences.

Once you've registered, you will be given a choice of ISO or CAB file type.  I'll go with ISO. The next choice is Product Language, and I will choose English.  Your browser will then let you download a 1.68 GB file, SQLServerVnextCTP2.0-x64-ENU.iso.  I will save that to my C:\Installs folder.

Once it is downloaded, navigate to your C:\Installs folder, right-click on file and select "Mount as a Virtual Drive", and select a drive letter.  I chose S: for SQL.

Pre-Install Checks

Now that the disc is mounted, navigate to the S: drive and run setup.exe.

From the Planning Section, it is a good idea to the run the System Configuration Checker.  This will check that you are an Admin on the machine, that the computer is not pending a restart, etc.  If you have installed SQL Server before, it appears to be the same checks as usual.  Click OK once the checks are done.


If you are upgrading from a prior version of SQL Server, click Download Upgrade Advisor.  The Upgrade Advisor has been renamed to the Data Migration Assistant.  Once it is installed, check the "Launch Microsoft Data Migration Assistant" checkbox and click on Finish.

 
 
 
I'll leave you on your own to further explore the Data Migration Assistant.
 

Installation

 
To start the Installation, click Installation and then  click "New SQL Server stand-alone installation or add features to an existing installation".  Since Developer Edition is now free, and has the full set of features, and unlike Evaluation does not have an expiration, choose Developer.  Click Next until you get to Feature Selection.
 
Since I am interested in exploring the new Machine Learning capabilities, I will select both R and Python in addition the database engine.  I am also selecting Integration Services and Documentation Viewer.
 
Click Next and then choose Default Instance or specify a name if you prefer a named instance.  I'll go with naming it SQL2017.

For service accounts, I'll go with the defaults, but check the "Grant Perform Volume Maintenance Task privilege to the SQL Server Database Engine Service" checkbox.  This option provides a performance boost by avoiding completely clearing files.

For Server Configuration, I'll go with the default of "Windows authentication mode" and click on the Add Current User button so my account will have access.  I will leave the Data Directories, TempDB, and FILESTREAM tabs with their defaults settings, and then click Next.

Click Accept and then Next on the following screens to accept the R and Python licenses.

Finally, click Install and the actual installation will begin.  On my desktop it took about 15 minutes for the installation to run.  A dialog indicating Computer Restart required then appeared.

Confirming Installation

If you don't already have SQL Server Management Studio, you can click on "Install SQL Server Mangement Tools" from the Installation section of the SQL Server setup.  Or, just go directly to https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms to download it.

In SQL Server Management Studio connect to the your SQL Server by entering <your computer name>\sql2017 as the Server name and specifying Windows Authentication.  Click New Query and enter:
select @@VERSION
Click F5 to run it and you should see a result of:
Microsoft SQL Server vNext (CTP2.0) - 14.0.500.272 (X64)   Apr 13 2017 11:44:40   Copyright (C) 2017 Microsoft Corporation. All rights reserved.  Developer Edition (64-bit) on Windows 10 Home 10.0 <X64> (Build 15063: )



 
 
 
 
 
 
 
 
 



 

Comments

Post a Comment

Popular posts from this blog

Jumping into Azure Data Lake

Image
Introduction You may have heard of Data Lakes and are wondering if it is the next big thing.   This post will provide an overview of Azure Data Lake, how to use it and some of its pros and cons. History of Data Lakes and Azure Data Lake The Data Lake term was coined by Pentaho in October 2010 to address limitations of a data mart, which typically has a subset of attributes and is aggregated.   Per Jamie Dixon’b Blog, the lake terminology was chosen since “the contents of the data lake stream in from a source to fill a lake, and various users of the lake can come to examine, dive in, or take samples.” Microsoft’s Azure Data Lake became generally available in November 2016, as described in this post: https://azure.microsoft.com/en-us/blog/the-intelligent-data-lake/ .   There are really three services that make up the data lake as shown in the diagram below.   The underlying technology for the data lake is based on Hadoop, but as an end user that is transparent.   You
Read more

Identifying Possible Price Fixing in the market of Ethacrynic Acid 25 MG tablets

  Executive Summary Ethacrynic Acid 25 MG tablets is the generic form of Edecrin, a loop diuretic that was originally approved by the FDA in 1967.   Ethacrynic Acid is the only loop diuretic that does not contain sulfa, so there are no substitutes for patients that need a loop diuretic but are sensitive to sulfa. There are multiple generic manufacturers of Ethacrynic Acid 25 MG tablets.   However, data from the National Average Drug Acquisition Cost provided by the Centers for Medicare and Medicaid Services show that the prices fluctuate over time but consistently move in lockstep.   Given the significant fluctuation in prices, the only rational conclusion is that the generic drug makers are colluding to fix the price at an artificially high level.   Background Etacrynic acid (INN) or ethacrynic acid (USAN), trade name Edecrin, is a loop diuretic used to treat high blood pressure and the swelling caused by diseases like congestive heart failure, liver failure, and kidney fail
Read more

Power BI Licensing Basics

Microsoft Power BI Licensing Basics Introduction Microsoft Power BI's licensing has evolved over time and can be a bit confusing.  The goal of this post is to clear up the confusion. Power BI Publishers vs. Consumers Within your organization there will typically be two categories of Power BI users: publishers and consumers.  Publishers are creating reports using Power BI Desktop and publishing them to the Power BI Service.  Consumers are viewing the reports and dashboards on the Power BI Service and interacting with them. Licensing Requirements Each publisher will need a Power BI Pro license.  The licensing for consumers is where it gets more interesting.  Each consumer also needs a Power BI Pro license, unless the report is in Power BI Premium capacity.  In that case, consumers just need to be assigned a Power BI Free license. Power BI Premium When you purchase Power BI Premium, you are buying capacity in the Microsoft Azure cloud, not a license.  There is no limi
Read more