Hands-On Project 2-1: Installing a SQL Server Instance In this hands-on project, you will install a new SQL Server named instance called SQLSERVERHOA. You may complete the installation using either the installation wizard or the command prompt.

1. Your installation should only include the database engine and Integration Services components. Add your local user account to the SQL System Administrators group for the SQLSERVERHOA named instance so you can administer it after the installation is complete. Keep all other default settings during the installation process. Once you have successfully completed the installation, save a copy of the summary.txt file located in C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\.

2. Verify that the Windows services for the database engine and Integration Services have been successfully installed using SQL Server Configuration Manager. Take a screen shot of this step.

3. Analyze the other system changes that resulted from this installation. Briefly list the steps that you took to review these changes.

After you have completed this hands-on project, submit the summary.txt file, a screen shot of the SQL Server Configuration Manager, and a list of the steps taken to analyze the systems changes to your instructor. Do not make any other changes to the SQLSERVERHOA instance, as you will use this for hands-on projects in upcoming chapters.

• Follow all 3 steps and organize the screen shot of the configuration manager and the list of steps you used to analyze the system changes in a word document.
• Make sure to label and give a description of your screenshots
• Create the correct named instance (SQLSERVERHOA)
• Make sure to add my username as an administrator: https://www.screencast.com/t/6FSWU8L4B
• Make sure to submit the summary.txt file
• You must do the work in the VM that was provided to you
• Organize all your screen shots and descriptions in a Word document, look at the attached document for an example