Install & Configure SQL Express

Step by Step instructions on how to install and configure SQL Express

Select a new SQL server stand-alone installation

Choose the Database Engine Services – if you are installing with Management Tool please select Management Tools when installing.

 

Use the default instance “SQLExpress”

 

Select mixed mode, add a password that is used for the SA account.

Next, define which users need to be added as SQL Administrators.

Add the current user and a user called “SYSTEM”