How to install Microsoft SQL Server Express in Windows

Home > Search > How-to
  by

To download both SQL Server Express (the server) and SQL Server Management Studio (the management app):

  1. Go to https://www.microsoft.com/en-us/download/details.aspx?id=42299
  2. Click on the download button.
  3. Check ExpressAdv 64BIT\\SQLEXPRADV_x64_ENU.exe.
  4. Check Express 64BIT\\SQLManagementStudio_X64_ENU.exe.
  5. Select Next.

Note: It is important that ExpressAdv 64BIT\\SQLEXPRADV_x64_ENU.exe (SQL Server Express with advanced options) is selected, so that you can use advanced features, such as full-text index. SQL Server Express with advanced options includes both SQL Server Express (the server) and SQL Server Management Studio (the management app).  If  ExpressAdv 64Bit\\SQLEXPRADV_x64_ENU.exe is not selected, you will need to download both SQLEXPR_x64_ENU (SQL Server Express) and SQLManagementStudio_X64_ENU (SQL Server Management Studio) It is much easier to just download ExpressAdv 64Bit\\SQLEXPRADV_x64_ENU.exe, so that both SQL Server Express (the server) and SQL Server Management Studio (the management app) are included in one package.

 

How to install SQL Server Express (the server) and SQL Server Management Studio (the management app)

  1. Go to your Downloads folder. Run SQLEXPR_x64_ENU to start the process of installing SQL Server Express (the server). A pop-up box appears. Select OK to extract the contents.
  2. Select New SQL Server stand-alone installation or add features to an existing installation
  3. License Terms: Select I accept the license terms and select Next
  4. Microsoft Update: Check Use Microsoft Update to check for updates (recommended) and select Next
  5. Feature Selection: Select the following:
    • Database Engine Services
    • SQL Server Replication
    • Full-Text and Semantic Extractions for Search (this allows us to enable full-text searching)
    • Management Tools - Basic
    • Management Tools - Complete
    • SQL Client Connectivity SDK
  6. Feature Rules: Keep all of the defaults checks and select Next
  7. Installation Type: It is okay to keep the Named Instance SQLExpress or to select your own name, and then select Next
  8. Server Configuration: Keep all of the defaults and select Next
  9. Database Engine Configuration: Keep all of the defaults and select Next
  10. After the installer completes, you should get Successed messages. Click Close.

Note: SQL Server Express (the server) takes about 2 GB of storage.

Note: SQL Server Management Studio (the management app) takes about 3 GB of storage.

 

To launch SQL Server Management Studio, select the Windows Start Icon > Microsoft SQL Server version > SQL Server version Management Studio. Select Connect, and you should be connected to SQL Server.

 

 



Add a Comment




We will never share your name or email with anyone. Enter your email if you would like to be notified when we respond to your comment.




Please enter in the box below so that we can be sure you are a human.




Comments