The purpose of this tutorial is to show how to install Microsoft SQL Server Advanced Express.

This is the copy of SQL Server Advanced Express used in this tutorial. I recommend getting the most recent copy from Microsoft and installing all service patches.

1] Using the mouse, double-click on the executable that you have downloaded.  (See Below!)
 

2] Using the mouse, double-click on the Run button.  (See Below!)

3] Using the mouse, double-click on the Next button.  (See Below!)

4] Using the mouse, double-click on the Install button.  (See Below!)
 

5] Using the mouse, double-click on the Next button.  (See Below!)

6] Using the mouse, double-click on the Next button.  (See Below!)

7] Enter your name and company. Using the mouse, double-click on the Next button.  (See Below!)
 

8] I recommend that you install everything on the local hard drive. Right-mouse click on each of the components and install them, in their entirety, on the local drive.  (See Below!)

9] One of the advantages of the advanced version is that it includes Management Studio Express. If you install the regular SQL Server Express, you should also download and install Management Studio Express when you are finished with this install. Using the mouse, double-click on the Next button.  (See Below!)

10] I recommend that you use Mixed Authentication; this will enable you to connect across the internet via web pages. Select a secure password that you can remember. Using the mouse, double-click on the Next button.  (See Below!)

11] Install the default configuration and configure the server. Using the mouse, double-click on the Next button.  (See Below!)

12] Select whatever you like here. Using the mouse, double-click on the Next button.  (See Below!)

13] Using the mouse, double-click on the Install button.  (See Below!)  

14] Using the mouse, double-click on the Next button.  (See Below!)
 

15] Using the mouse, double-click on the Finished button.  (See Below!)

16] You should be able to start SQL Server Management Studio Express as illustrated below. Try it!

17] You should be able to connect with either Windows Authentication. Try It. Using the mouse, double-click on the Connect button.  (See Below!)

18] The circle with the green triangle indicates that the database engine is running. The name of the database instance is generally the name of your computer --> followed by \sqlexpress. (See Below!)

19] If you right-mouse click on the server instance, you can stop the database.   (See Below!)

20] There are a number of other ways to start and stop the Microsoft SQL Server Express database server, including using the services functionality.
 

21] You are now ready to create a database and add data. You might want to check out the tutorial below!