Getting and Understanding Your Tools - Beginning C# 5.0 Databases - page 2

• Troubleshooting the SQL Server service
• Installing the AdventureWorks sample database
Obtaining Visual Studio 2012
This topic requires Visual Studio 2012 to be installed on your computer. At the time of this writing, the
available version of Visual Studio is Visual Studio 2012 Developer Preview. To find download
information about Visual Studio 2012, go to http://msdn.microsoft.com/vstudio .
You can also directly download the installer ISO image files from the MSDN Subscriptions site at
http://msdn.microsoft.com . Ac cess the downloadable setup files by clicking the Visual Studio link in the
Developer Center; then extract the downloaded file and run Setup.exe .
If you have a setup DVD or CDs of Visual Studio 2012, just put the DVD or CD1 into your computer's
disk drive and complete the setup by following the instructions, making sure you have enough disk
space on your C drive.
Visual Studio 2012 has various software components, so you need to decide whether you want to
install them when installing Visual Studio. The examples in this topic require only the C# language
component, but you may want to install other languages such as VB .NET, VC++, and F#, and so on, for
your future programming needs.
Installing SQL Server 2012 Express
To install SQL Server 2012 Express for the purposes of working through the examples in this topic, follow
these steps:
1. Go to www.microsoft.com/betaexperience/pd/SQLEXPCTAV2/enus/default.aspx .
Decide which version you need based on your CPU architecture, 32-bit or 64-
bit, and in the Select Product drop-down, select Express with Tools. Then click
Download.
2. The Download Manager will begin. If the Download Manager is not already
installed on your computer, then it will prompt you to install it. Click Install.
3. Based on whether you chose the 32-bit or 64-bit version, you will be prompted
to save the file SQLEXPRWT_x86_ENU.exe or SQLEXPRWT_x64_ENU.exe , which is the
SQL Server 2012 Express setup utility.
4. Save this file to a location on your host computer (such as on your desktop).
When the download of the file is complete, click Close.
5. Run the file to begin the installation, and follow the steps to install it.
6. When the Completing the SQL Server Management Setup window appears,
click the Finish button.
7. After a successful installation, you will see all the SQL Server components
installed in your Start All Programs Microsoft SQL Server 2012 menu. It is
important to make sure your SQL Server service is running, so to verify that,
you need to invoke the Services list. Go to Start Run  Services.msc or Control
Panel Administrative Tools Services. A Services window will load; scroll
down until you see SQL Server service listed, as shown in Figure 1-1.