Download Instructions

Use the following step-by-step instructions as a supplement to the instructions provided in your text book for downloading the most recent versions of Microsoft's SQL Server Express Edition and the Microsoft SQL Server Management Studio (SSMS).

Downloading the MS SQL Server Installation Center

Step 1: Go to the download page for SQL Server 2016 Express http://Microsoft.com/SQL and click on the Download button, then click on the Download now button for the Express edition on the SQL Server downloads page as shown in figure 1:

Step 2: Once you click the Download now button an executable file will be downloaded to your computer's Downloads folder, the file should look like the one shown in figure 2. Double-click the exe file to invoke the installation process. Then, click the Yes button to allow the app to make changes when prompted by your Windows Account Control security window pops up.

Step 3: The first screen you see in the installation process should be the SQL Server 2016 with SP1 Express Edition Select an installation type screen as shown in figure 3. Click on the Custom option.

Step 4: On the next screen, you see the SQL Server 2016 Specify SQL Server media download target location screen as shown in figure 4. This determines where the installation program will download all of the files it needs to complete the setup process; generally you should just accept the default folder as long as you have enough free space on that partition. Click on the Install button to begin the download process.

Step 5: You should now see that the install package is being downloaded to your computer as shown in figure 5. Once the download is complete the SQL Server Installation Center should appear, as shown in figure 6.

Once the SQL Server Installation Center screen appears you have several choices to choose from. For the purposes of the CSIS 105A and CSIS 116B courses you will only need to install two components:

• The Microsoft SQL Server Express Edition w/LocalDB
• The Microsoft SQL Server Management Studio (SSMS)

Instructions for installing each of these components are listed below.

How to Install SQL Server Express Edition

Step 1: On the SQL Server Installation Center screen click the top option, New SQL Server stand-alone installation or add features to an existing installation. If you have an existing installation of SQL Server, the installation program first checks to see if there are any updates and leave you on the Products Update screen. If this occurs, just click the Next button, most of you will not see this screen.

Step 2: The next screen asks for the target location for installing SQL Server. Again, just accept the default settings, unless you don't have enough space on the suggested partition, then click the Next button.

Step 3: The next screen you see should be the License Terms screen. Click to put a check in the I accept the license terms checkbox, and then click the Next button.

Step 4: The next screen you see should be the Feature Selection screen. Scroll down the list of features to the bottom and click to put a check in the LocalDB check box (as shown in figure 8). Also, double-check the Instance root directory's default path to see that it is set to a partition that has enough space for the installation of SQL server, and then click the Next button.

Step 5: The next screen you see should be the Instance Configuration screen as shown in figure 9. Don't change anything on this screen, just click the Next button.

How to Install the SQL Server Management Studio (SSMS)

Step 1: Go back to the SQL Server Installation Center (where you first began the actual SQL server installation process) and select the option Install SQL Server Management Tools. Just accept all of the default settings during the install process.