SQL Server 2017 Installation Screenshot Tour (Windows)

SQL Server 2017
16 Comments

It’s like an unboxing, but with setup.exe. For the vast majority of setup, it’s the same as 2016:

Setup.exe opens, then click the Installation tab on the left
The better part of Setup.exe
Pick your edition – I’m going with Developer because I’m a…wait….
Yep, Developer Edition still phones home and you can’t turn it off
Feature selection – I’ll take most of the engine goodies
Picking your instance name
Configuring service accounts, Instant File Initialization isn’t checked by default
Choose your sysadmins wisely
Mommas don’t let their babies put their files on the C drive
TempDB data & log files can finally default to over the size of a USB thumb drive! Nice little warning popup about how you might have a slow setup experience though
Filestream, whatever
Arrr, matey. After you click Accept, it sits here for a while before Next is enabled, then you have to click that too
Same thing with the Python install – accept, wait, next
All systems go – click Install
This “CPU action” (or lack thereof) has always been the slowest part of install for me
More hot CPU action (stuck here for minutes)
The 2017 installer was voted Most Likely to Succeed

And you’re done! Time to reboot, then start querying DMVs looking for surprise gifts.

Don’t forget to fire up Configuration Manager and enable TCP/IP
Previous Post
[Video] Office Hours 2017/09/27 (With Transcriptions)
Next Post
New Wait Stats and DMV Columns in SQL Server 2017

16 Comments. Leave new

  • What? No errors where the accounts don’t have enough permissions to start the services during the install?

    Reply
  • I got below error as sql 14 already there. Please suggest.

    Feature: Database Engine Services
    Status: Failed
    Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail.
    Next Step: Use the following information to resolve the error, and then try the setup process again.
    Component name: Microsoft Visual C++ 2015 Redistributable
    Component error code: 5
    Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180129_115141\VCRuntime140_x64_Cpu64_1.log
    Error description: VS Shell installation has failed with exit code 5.

    Reply
    • Neeraj – we’re not really your personal support department here. If you have a problem with a Microsoft product’s installation, contact Microsoft.

      Reply
    • Open Control Panel & Uninstall Microsoft Visual C++ 2017 Redistributable Components both x86 & x64 and again start install SQL from starting

      Reply
  • I cant install sql server 2017 Developer edition in Windows 8. It stuck at Cpu64_Action Screen, I left it overnight for installation till morning it was on that screen. Even i tried on installing database engine deselecting all other things, but no luck.

    Reply
  • Thanks for the tour, I’m looking to install SQL 2017 myself and it is definitely handy to see if there have been any changes from past installs before I begin.
    I noticed that you have installed the root directory (program files) off of the C drive. Is this a better practice?

    Reply
  • It says see the bottom of setup page for error messages. Where is that?

    Reply
  • Hi Brent,

    While installing SQL server 2017 developer edition on windows 8, I found error : “Python install failed. check logfile”.
    Final Status :
    Python : failed
    machine learning Serveces (In – database) : Succeeded
    Database engine service : Succeeded.

    Please help me so that i could access Python on SQL server instance .

    Reply
  • We are having an issue installing sql Server 2017 on windows server 2019, post restart it hangs at the login screen stating user profile services and does not move, any solutions to address this

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.