Install SQL Express Server

Summary

This Instruction Article explains how to install SQL Express Server.

Estimated Time Required

SQL Download – 30 min to 2 hour depending on bandwidth
SQL Express Install – 30 min to 1 hour depending on PC processor speed and RAM
Total: 1 hour to 3 hours

Instructions

Check Prerequisites (Click to Expand)

  • Check for Local Administrative Rights with credentials used/given (see Article KBA-01077-N4L7M9)
  • Download of the latest SQL Express 2012
  • .NET Framework 3.5 SP1 installed (dotnetfx35setup.exe see link to download)
  • Confirm recommended resources allocated:
  • 1 GB or more RAM
  • 6 GB or more disk space
  • 800 x 600 or higher screen resolution
  • Check compatible operating systems: Windows Server 2012, Server 2012 R2, Server 2008, Server 2008 R2, Windows 8, Windows 7, and Vista.

Pre-Install Configuration (Click to Expand)

  • Add .NET Framework 3.5.1 using the Role Management (Application Server).
  • Run Windows Updates

Install (Click to Expand)

  1. Run (as administrator) installer file (e.g. SLEXPADV_64_ENU).
  2. Select “New SQL Server stand-alone installation or add feature to an existing installation” option.
  3. Read and accept the EULA.
  4. Accept the default features (Database Engine Services and Management Tools are the most critical) and default directory.
  5. Name the SQL Instance (16 digits w/no dashes, name should indicate SQL version and software that will use it e.g. BARTSQL2012)
  6. Make sure SQL Browser Service is selected for “Automatic” start-up and accept defaults on the other Services Accounts screen.
  7. Select Authentication Mode (recommended Mixed Mode using Efficient! as the default password) and add any administrators (local administrator recommended)
  8. Allow default for Reporting Service Native Mode screen
  9. Allow default for Error Reporting screen

Post-Install Configuration (Click to Expand)

To make the SQL Express instance visible to other computers on the network, the SQL Browser Service needs to be started.  Named Pipes needs to be Enabled (Protocols for SQL instance)

Validation Testing (Click to Expand)

Run SQL Management Studio, attempt to connect to the database using the ‘sa’ account credential

Have the following files available:

  • Correct version of SQL Express files available (SQL Express 2012 with Advanced Tools)
  • Microsoft .Net Framework 3.5 SP1

Outside Sources and Helpful Links

Additional Comments

Updated on August 2, 2017

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support