SQL Server 2008 R2 Installation
- Run the setup.exe of your SQL Server 2008 R2 x64 installation DVD.
- Click “Installation” (on the left side).
- Click “New installation or add features to an existing installation“.
- Setup Support Files screen: Click OK.
- Product Key screen: Enter the product key for the version of SQL Server 2008 R2. I usually install the Standard version. Click Next.
- License Terms screen: Click Next.
- Setup Support Files screen: Click Install.
- Setup Support Files screen: You may see some warnings. You can ignore the Windows Firewall and Computer Domain Controller warnings since this is for a development environment. Click Next.
- Setup Role screen: Select SQL Server Feature Installation. Click Next.
- Feature Selection screen:
- Select the “Database Engine Services” feature.
- Select the “Management Tools – Basic” feature. The Management Tools – Complete will auto select. Click Next.
- Installation Rules screen: Confirm thre are no Failed or Warning items by clicking the Show details button. Click Next.
- Instance Configuration screen: Keep the Default instance selected, click Next.
- Disk Space Requirements screen: After validating the hard disk requirements, click Next.
- Server Configuration screen: Click “Use the same account for all SQL Server services”.
- Enter your SQL Service domain account.
- You don’t need to change the default collation settings given by the installation wizard.
- Click Next.
- Database Engine Configuration screen:
- Select “Windows Authentication”.
- Click “Add Current User” as a SQL Server administrator. Or, add any additional user accounts you want to have DB admin rights.
- Click Next.
- Click Next a few times and then click Install to start the installation.
SQL Server 2008 Configuration
- Open SQL Server Configuration Manager.
- Expand the SQL Server Network Configuration node.
- Select the Protocols for MSSQLSERVER node.
- You have to enable “Named Pipes“.
- Restart your computer.