Installing SQL 2008 R2

To install SQL 2008 R2, perform the following steps:

1. Double-click Setup on the SQL 2008 R2 DVD.

2. If the .NET framework is not already present, the wizard requests it. Click OK to enable the wizard to install the .NET framework.

3. When the SQL Server Installation Center displays, as shown in Figure 11.1, click Installation in the left pane, and then click New installation or add features to an existing installation.

Figure 11.1 The SQL Server Installation Center

4. After the Setup Support Rules Wizard runs, and if all checks pass, click OK.

5. When the wizard prompts, enter your product key and click Next.

6. Read the licensing terms. If you agree, check the box next to I accept the license terms and then click Next.

7. Click Install to set up the support files.

8. When the support rules are completed, review the status. If all operations pass, click Next. Otherwise, click the status for additional information and perform the recommended remediation.

9. When the Setup Role wizard launches, as shown in Figure 11.2, choose SQL Server Feature Installation and click Next.

Figure 11.2 The Setup Role Wizard

10. Select the features you want to install and select the paths to which they should be installed. The features chosen depend on the roles you plan to use in Lync Server. Click Next.

11. If all operations pass, click Next. Otherwise, click the status for additional information and perform the recommended remediation.

12. Choose Default Instance and click Next.

13. Review the disk space usage summary and click Next.

14. Choose the accounts to use for running the SQL services as shown in Figure 11.3 and enter passwords if they are to be named accounts. Leave the startup types as default. Click Next.

Figure 11.3 Configuring SQL Service Accounts

15. Choose the authentication mode to be used, as shown in Figure 11.4.

Figure 11.4 Choosing an Authentication Mode

16. Add SQL Server administrators, and then click Next.

17. Choose whether to participate in error reporting back to Microsoft. Click Next.

18. If all configuration operations pass, click Next. Otherwise, click the status for additional information and perform the recommended remediation.

19. Review the feature summary and click Install.

20. When the installation is completed, click Close.