SQL EXPRESS Configuration

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”