Install and Configure SQL Server

The installation steps describes how to install Microsoft SQL Server 2008 R2 Standard Version on Microsoft Windows Server 2008 R2.

Note: Please note that you may have to use other versions of SQL Server, such as Enterprise or Datacenter depending on your requirements such as performance and cube features.

This installation guide is for the following base configuration:

Installation Steps

  1. Download Microsoft SQL Server 2008 R2 Standard Version.
  2. Run setup as Administrator.


  3. Click Installation and then New installation or add features to an existing installation.

  4. Check the status of the setup support rules and click OK.
     

  5. Enter the product key and click Next.
     

  6. Accept license terms and click Next.
     

  7. Click Install.


     

  8. Check the status for the setup support rules and click Next.

  9. Select SQL Server Feature Installation and click Next.

  10. Select Data Engine Services, Analysis Services, Reporting Services, Integration Services and Management Tools - Basic.

  11. Check the installation rules and click Next.

  12. Select Default Instance and click Next.

  13. Check the disk space requirement and click Next.

  14. Specify user account for each service. Microsoft recommends you to specify an individual account for each service. The service accounts used for this configuration must have a strong password otherwise you will get the error "Invalid or missing username or password". To continue, provide valid credentials for the SQL Server Agent service. A strong password is one that has a combination of letters in uppercase, lowercase, numbers and special characters.
    For more information refer Setting up Windows service accounts on MSDN.


     

  15. On the Database Engine Configuration page, choose the authentication mode to use for your SQL Server installation. Select Mixed Mode Authentication if using both Windows and SQL Server authentication. Enter and confirm the password for the system administrator login. Click Next.

    In the Analysis Services Configuration page specify which users have administrative permission for Analysis Services.

  16. Select Install the native mode default configuration.

  17. Select Installation Configuration Rules and click Next.

  18. Check the summary and start installation by clicking Install.

  19. Installation is completed.



Read More