1] If you are going to install Visual Studio 2008,  I recommend that you do it first.

Tutorial: VisualStudio-2008-Install

2] I recommend that you install all service packs for your operating system before you begin.  My students often skip the requirements and waste installation time because Microsoft SQL Server 2008 Advanced will simply not install unless you have the following software on your computer:

1] Using the mouse, double-click on the installation software. (See Below!)

2] Using the mouse, select the Installation tab on the left. Select New SQL Server Stand-Alone Installation on the right. (See Below!)
 

3] Hopefully you will have nothing to correct in the failure listing below. Once you get the opportunity, push/select the OK button at the bottom. (See Below!) 

4] Using the mouse, select/push the Next button at the bottom. (See Below!)

5] Read and accept the license agreement. Using the mouse, select/push the Next button at the bottom. (See Below!)

6] Using the mouse, select/push the Install button at the bottom. (See Below!)

7] Note that my system passed all of the required support rules. The ability to access this server, from a remote system, can be blocked by any software firewall. I normally keep my firewall off when behind a router and enable it if I am using the computer in a public venue. You might also have warnings from anti-virus systems that help to protect your ports.  I am going to click on the Windows Firewall warning below.

8] It is beyond the scope of this tutorial to open the Windows Firewall ports to enable remote server access across a network. You can get directions to do so by following the Microsoft link below. Write down the link. Using the mouse, push/select the OK button. (See Below!)

9] Using the mouse, select/push the Next button at the bottom. (See Below!)

10] Using the mouse, select/push the Next button at the bottom. (See Below!)

11]  Read through and Accept the License Agreement. Using the mouse, push/select the Next button. (See Below!)

12] Using the mouse, push/select the Select All button. Using the mouse, push/select the Select All button.

Using the mouse, push/select the Next button at the bottom. (See Below!)

14] Using the mouse, push/select the Next button at the bottom. (See Below!)

15] We must now provide access authentication. You must use some administrative account to install the service. Replace the thicks & corresponding password with an administrative account on your server.  Using the mouse, select/push the Next button. (See Below)

I would like my students to add thicks, administrator, and each person in their server group.

17] Using the mouse, select/push the Next button. (See Below)

18] Using the mouse, select/push the Next button. (See Below)

19] Using the mouse, select/push the Next button. (See Below)

20] Using the mouse, select/push the Next button. (See Below)

21] Progress Window. (See Below)

22] Using the mouse, select/push the Next button. (See Below)

23] Using the mouse, select/push the Close button. (See Below)

24] Using the mouse, select/push the OK button. (See Below)
 

25] Restart the computer.
 

1] Open the Control Panel. Using the mouse, double-click on Administrative Tools. (See Below!0

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

3] If you followed the installation directions above and rebooted your computer, you should see instance SQL of SQL Server started automatically. Note that this system has instance SQLEXPRESS running as well; it was installed with Visual Studio. It is ok to have both running.. (See Below!)

1] Using the mouse, hold down the Start Menu --> Select Microsoft SQL Server 2008 --> Select SQL Server Management Studio

2] Although I could simply enter the server name, I am going to use the server name drop-down to search for it; using the mouse, hold down the drop-down --> Select Browse for more ...

3] Expand Database Engine. Select the SQL instance. The name of my computer is Laptop; this name precedes both server instances. (See Below)

4] I could have simply typed in LAPTOP\SQL for the server name. Using the mouse, push/select the Connect button. (See Below)