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.
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.
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.
15. Choose the authentication mode to be used, as shown in Figure 11.4.
Choose mixed mode if your environment doesn’t have a policy against local SQL SA accounts. This enables a local way to authenticate SQL should the system be unable to contact the domain. Set a complex password if a local SA will be used.
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.
Don’t forget to run Windows Update to look for SQL-related patches.