SQL Configuration › Install Microsoft SQL Server 2008 R2 Standard

Install Microsoft SQL Server 2008 R2 Standard

Follow these steps:

1. Log in as the local Administrator or a user with administrative rights to the server.
2. Connect to the media.

   Note: Version Used is en_sql_server_2008_r2_standard_x86_x64_dvd_521546.

3. Double-click SETUP.
4. Click OK, and wait until the SQL Server Installation Center opens.

   Note: The following steps 5 – 8 can be skipped and you can go directly to Step 9 to start the installation.

5. Verify that Planning is selected (Bold).
6. Click the System Configuration Checker.
7. Verify that the status for Operation completed and Setup Support Rules is Passed. If the status is Failed, correct them. Warning issues must be corrected but are not required.
   1. Click Show details to see issue details.
   2. After the problem is corrected, click Re-run to run the Setup Support Rules again.
8. Click OK to close the System Configuration Checker.
9. Select Installation.
10. Click New installation or add features to an existing installation.
11. Verify that the status for Operation completed and Setup Support Rules is Passed. If the status is Failed, correct them. Warning issues must be corrected but are not required.
    1. Click Show details to see issue details.
    2. After the problem is corrected, click Re-run to run the Setup Support Rules again.
12. Click OK.

    The Product Key page opens.

13. Enter the product key, and click Next.
14. Select the option I accept the license terms, and click Next.
15. Verify that no Setup Support Files are required.
16. Click Install.
17. A status bar appears with the status In Progress while the Setup Support Rules are checked.
18. Verify that the status for Operation completed and Setup Support Rules is Passed. If the status is Failed, correct them. Warning issues must be corrected but are not required.
    1. Click Show details to see issue details.
    2. After the problem is corrected, click Re-run to run the Setup Support Rules again.
19. Click Next.
20. Verify that SQL Server Feature Installation is selected, and click Next.
21. Select the following Features:
    1. Database Engine Services
    2. Client Tools Connectivity
    3. (Optional) SQL Server Books Online
    4. Management Tools - Complete
22. Change the Shared feature directories if you wish to change the installation location, and click Next.
23. Verify that the status for Operation completed and Installation Rules is Passed. Several rules have the Skipped status.
    1. Click Show details to see issue details.
    2. Click Re-run to run the Installation Rules again.
24. Click Next.
25. Verify that the Instance ID, and the Directory settings are correct, and click Next.
26. Verify that the Disk Space Requirements are checked, and click Next.
27. Click the drop-down field under Account Name and select NT AUTHORITY\SYSTEM for SQL Server Agent and SQL Server Database Engine.
28. Click Next.
29. Fill the following fields:
    • Select Mixed Mode and enter a password for the sa account.
    • Click Add Current User to add the local Administrator account.
    • Click Add to add additional accounts from the local or Domain user account database
30. Click Next.
31. Verify the Error Reporting page, and click Next.
32. Verify that the status for Operation completed and Installation Rules is Passed. Several rules have the Skipped status.
    1. Click Show details to see issue details.
    2. Click Re-run to run the Installation Rules again.
33. Click Next.
34. Review the Ready to Install information.
35. Click Install. Click Close.
36. Close the SQL Server Installation Center.