There is a point to this story, but it has temporarily escaped my mind...
Contact Me MyFaceBook MyLinkedIn MyGitHub MyTwitter

Install Microsoft SQL Server

  1. Click on the “Download SQL Server 2012 Express” button and log into your Microsoft account.
  2. Select “SQL Server 2014 Express” for your platform (32-bit or 64-bit)
  3. Then click “Continue”
  4. Once the file is downloaded, execute it.
  5. In the SQL Server Installation Center window, click on “Installation”
  6. Click on “New SQL Server stand-alone installation or add features to an existing installation”
  7. Make sure that “Include SQL Server product updates” is checked then click “Next” on the Product Updates window.
  8. Select “Perform a new installation of SQL Server 2014, then click “Next” on the Installation Type window
  9. Click “I accept the license terms”, then click “Next” on the “License Terms” window.
  10. On the Feature Selection window, select the following features, and then click “Next”:
    1. Database Engine Services
    2. SQL Server Replication
    3. SQL Client Connectivity SDK
  11. Select “Default instance,” and then click “Next” on the Instance Configuration window.
  12. On a development machine, change the Startup types for each service to Manual.
  13. Click “Next” on the Server Configuration window.
  14. On the Server Configuration tab of the Database Engine Configuration window:
    1. Change Authentication Mode to “Mixed Mode”
    2. Type and confirm a complex “sa” account password.
    3. Click on “Add Current User” on development machines.
    4. Click “Add” on non-development machines and add the local administrators group.
  15. On the Data Directories tab of the Database Engine Configuration window:
    1. On development machines and single drive servers, change the “User database directory” to “C:\data”
    2. On multi-drive servers:
      1. change “User database directory” to the “DATA” drive
      2. change “User database log directory” to the “LOG” drive
      3. change “Temp DB directory” to the “TEMPDB” drive
  16. Click “Next” on the Error Reporting window.
  17. Click “Next” on the Installation Configuration Rules window.
  18. Click “Install” on the Ready to Install window.
  19. When the installation completes, click “Close”.
Copyright © 2015 by Julian Easterling. SOME RIGHTS RESERVED.

Creative Commons License
Except where otherwise noted, content on this site is
licensed under a Creative Common Attribution-Share Alike 4.0 International License.


All of the opinions expressed on this website are those of Julian Easterling and
do not represent the views of any of my current and previous clients or employers in any way.

If you notice an error on the site or content that has not been properly attributed, bring
it to my attention using the contact page and I will endeavor to fix it as soon as I can.

I accept no responsibility or liability for any damages incurred by following any of
my advice or by using any of the information on my site or of those sites that I link to.