Exercise 5: Install SQL Server 2008 Enterprise

Note:
In this exercise you will install the Enterprise version of SQL Server 2008.
  1. In this step, you will download the free trial version of SQL Server 2008 from the Microsoft download site using the following URL. Note that this free trial version is set to expire in 180 days after installation. If you have a registered version of SQL Server and a product key, you can install that instead of the free trial version in order to having the software expire in 180 days.
    1. Download the installation software to the hard drive of your host machine from this URL:
    2. After downloading, extract the ISO file named SQLFULL_ENU.iso.
    3. Inside the Hyper-V Manager, go to the settings for WingtipServer VM and mount SQLFULL_ENU.iso as to VM

      Figure 1

      Settings for WingtipServer

  2. Logon to the VM and begin the installation of SQL Server 2008.
    1. Logon to the VM as Wingtip\Administrator with password of Pass@word1.
    2. Open the Widows Explorer navigate to the DVD drive.
    3. Double click on setup.exe to begin the installation process.
    4. A dialog warns you that you must install Service Pack 1 after installing SQL Server 2008. Accept the following dialog by selecting Don’t show this message again and clicking the Run Program button.

      Figure 2

      A dialog warns you that you must install Service Pack 1 after installing SQL Server 2008.

    5. The setup process should now show the following window. Click the Installation link on the left-hand side of the window and then click the link which reads New SQL Server stand-alone installation oradd features to an existing installation.

      Figure 3

      SQL Server Installation Center

    6. There are several windows at the beginning of the installation process that you should click Next to advance the installation process. At the Product Key page, select the Enterprise Evaluation and click Next to continue.

      Figure 4

      Product Key page

    7. The next page is the Setup Support Files page. Click Install to continue.

      Figure 5

      Setup Support Files

    8. When you get to the Setup Support Roles page of the setup wizard, the installation process runs tests to make sure your VM meets the requirements. Your VM should pass all tests and the only warning you should receive is that you are installing SQL Server 2008 on a domain controller.

      Figure 6

      Setup Support Roles

    9. When you get to the Feature Selection page, select the features as shown in the screenshot below. Click Next to continue.

      Figure 7

      Feature Selection page

    10. There is nothing to change on the Instance Configuration page. Click Next to continue.

      Figure 8

      Instance Configuration

    11. The next page is the Server Configuration page. Click the button with the caption of Use the same account for all SQL Server instances. When the dialog appears to select a user account, select the System account (NT AUTHORITY\SYSTEM) and click OK.

      Figure 9

      Server Configuration page

    12. After you have completed the previous step, the Server Configuration page should appear like the one shown below. Click Next to continue.

      Figure 10

      Server Configuration page

    13. The next page is the Database Engine Configuration page. Specify WINGTIP\Administrator as a SQL Server administrator by clicking the Add Current User button at the bottom of the page. After the page looks like the one below, click on the FILESTREAM tab so that you can make changes there.

      Figure 11

      Database Engine Configuration page

    14. On the FILESTREAM tab of the Database Engine Configuration page, select the options for Enable FILESTREAM for Transact-SQL access and Enable FILESTREAM for file I/O streaming access. Click Next to continue.

      Figure 12

      Database Engine Configuration

    15. On the Analysis Services Configuration page, specify WINGTIP\Administrator as an Analysis Services administrator by clicking the Add Current User button at the bottom of the page. Click Next to continue.

      Figure 13

      Analysis Services Configuration page

    16. On the Reporting Service Configuration page, select the last option to Install, but do not configure report server. Click Next to continue.

      Figure 14

      Reporting Service Configuration page

    17. At the Installation Rules page, verify that your VM passes all tests. Click Next to continue.

      Figure 15

      Installation Rules page

    18. No changes are required on the Error and Usage Reporting page. Click Next to continue.
    19. No changes are required on the Installation Rules page. Click Next to continue.
    20. No changes are required on the Error and Usage Reporting page. Click Next to continue.
    21. On the Ready to Install page, click Install to begin the installation. The installation will take somewhere between 5 and 20 minutes depending on your hardware performance.
    22. When the installation is finished the Installation Progress page will display a Setup progress complete message. Click Next to continue.

      Figure 16

      Installation Progress page

      When you get to the Complete page you are finished with the installation. Click the Close button.

      Figure 17

      Complete page

  3. Install SQL Server 2008 SP1
    1. Go to the download page at the following URL
      Note:
      https://www.microsoft.com/downloads/details.aspx?familyid=66AB3DBB-BF3E-4F46-9559-CCC6A4F9DC19&displaylang=en
    2. Download the 64-bit version which is SQLServer2008SP1-KB968369-x64-ENU.exe.
    3. Double click this EXE begin installation. Take all default options to install SP1.
  4. Install SQL Server 2008 SP1 CU2
    1. Go to the download page at the following URL.
      Note:
      https://support.microsoft.com/kb/970315
    2. Click the View and request hotfix downloads link at the top of the page. Follow instructions to obtain and install this hotfix on your VM.
  5. Install Adventure Works Databases
    1. Go to the download page on CodePlex at the following URL.
      Note:
      https://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=34032
    2. Download the x64 version SQL2008.AdventureWorks_All_Databases.x64.msi.
    3. Install this MSI file on your VM to install the Adventure Works database.
  6. Build Adventure Works Cube using SQL Server Business Intelligence Development Studio.
    1. Launch SQL Server BI Development Studio by using the shortcut in the Windows start menu: Start > All Programs > Microsoft SQL Server 2008 > SQL Server Business Intelligence Development Studio.

      Figure 18

      SQL Server Business Intelligence Development Studio

    2. From within Business Intelligence Development Studio, you the File > Open Project menu command to open the project at the following location.
      Note:
      C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks 2008 Analysis Services Project\enterprise\Adventure Works.sln
    3. With the project open, right click on Adventure Works DW 2008 project node and execute the Deploy command. The deployment process will take a minute or two to build out the Adventure Works data warehouse cube. You will receive a deployment success message after the deployment process completes.

      Figure 19

      Deploy command