In this article we will be learning how to install Microsofts SQL Server 2008 for a Windows computer. This tutorial will require that you download the express version of SQL Server from the Microsoft Site. This will allow us to use the Microsoft SQL Server 2008 engine without having to pay money for it. When reaching the site we will need to choose whether or not we want x64 bit or x32 bit. In this instance I chose x32 as it can be used on either a 32 or 64 bit computer.

 

After clicking the 32 bit installation option you will be redirected to the image above which when clicked will allow you to download the Express version of Microsoft SQL Server 2008.  Once the download is finished we need to find it and open it.  Once open we can then start configuring the installer.


The first screen we will see is the SQL Server Installation Options screen which will allow us to pick the red option above and begin our journey on installing Microsoft SQL Server. After this is done we will then need to agree to the licensing terms which will turn out to be the next screen.

All that is required is checking the I accept box and I chose to send Microsoft data but the choice is totally yours. After clicking next on the Licensing Screen we will be taken to a page where support files will be installed to help the installation of SQL Server 2008.  After this is completed you will be taken to the Feature Selection screen where you will need to decide what components (instance specific and shared) you will require installed.  To be clear, instance specific items are used only within that singular install as opposed to shared items that will be distributed to all instances of SQL Server.  I chose to go with everything provided to us as we may need to use it in later tutorials.

Up after pressing the next button is the Instance Configuration screen which will allow you to name this current install of SQL Server 2008.  As already have a couple instances of SQL Server 2008 installed I chose to name mine “MSSQLSERVEREXP” but you may chose the default instance name which will not affect us moving forward.

Next us is the Server Configuration screen which will allow us to define the default accounts that can use these services.  We just need to leave them the way they are and progress onto the next screen.

We now need to decide whether or not we want to be able to use ONLY Windows user authentication mode or if we wanted to make it a mixed mode authentication.  Mixed mode will allow us to use the Windows authentication if we like but we can also use SQL Server Authentication.  This means that the user below will be able to log in using the password we have set above.  I chose to use mixed mode as I find using the SQL Server authentication preferable.  We will not need to touch the other tab at the top as we don’t need to change where our Server will be installed to. After you have completed this it is time to move on.

This Error Reporting screen will afford us the opportunity to submit the install data to Microsoft so that if there is a problem it will automatically be sent to hopefully find a solution.  I chose to check this as I have no issues sending this information.  After you have decided to check or not to check the box we can move on.

This is the final stage of the installation; the installation itself.  This is an autopilot screen and we can now take a break, get a coffee and come back in about 30 minutes to hopefully a completion screen.  After the install you should see the completion screen below, along with a message box that will ask you to restart your computer to complete the install.

After the install is complete we now have a fully functional SQL Server 2008 install and can now create databases for any projects that may come across this site and need a database to store the data to.  If you are looking for information on creating a database using SQL Server Management Studio this site would be most beneficial. Until next article, Happy Hacking!

Share This