I’m setting up SQL 2016 Standard for low-volume use. All I want is to put the programs on the C: drive and all data (including error logs, system and user databases and logs) on the D: drive. I missed some things during the first installation and had to start over. Twice. This time I made screen shots.
Keep in mind that during the install wizard, you can move back and forth between panes to see the effects of your selections. That sure beats starting from scratch!
On the Feature Selection pane, I chose to install Database Engine Services, Full-Text and Semantic Extractions for Search, Client Tools Connectivity, and Integration Services. Careful on the Feature Selection pane. If you change the Instance root directory, the data is moved but the SQL binaries will be on the D: drive as well. Not what I wanted. Just leave the instance root as C\:Program Files\Microsoft SQL Server\.
The next screen shows you were the SQL Server directory will be. This is, in fact, where I want the binaries:
I didn’t change anything on the Server Configuration pane.
Pay close attention to the Database Engine Configuration pane. It has several tabs. Set up your user(s) on the Server Configuration tab. The Data Directories tab allows you to modify folders. This is what we’ve been looking for. Just change the Data root directory and the rest will follow, including the grayed-out System database directory:
The TempDB tab does allow changes, but I didn’t change anything here:
Scroll down in the Ready to Install pane to double-check the directories:
That did it: the C: drive has binaries and the D: drive has data: