Installing SQL Server 2008 on Windows Server 2008 R2

To install SQL Server 2008 on Windows Server 2008 R2 you have just to add the feature .NET Framework 3.5.1, this feature will enable the SQL Server Installer to run.

To verify the system requirements you can use the System configuration checker from the SQL Server Installation Center under the Planning section as illustrated on the figure above.

When you launch the SQL Server Installer you will see on your screen the fallowing message informing you that you have to upgrade your SQL Server installation to Service Pack 1 which is required for the compatibility with Windows Server 2008, so you have to click Execute the program and don't forget to apply the Service Pack 1 of SQL Server 2008 after finishing installation.

After verifying that all system requirements are meet you can start the installation process of SQL Server 2008 from SQL Server Installation Center under the installation Section by clicking on New SQL Server stand-alone installation or add features to an existing installation.

• When running the installation process ensures that you are using a user account having administrator privileges on the machine or the installation will fail.
  
• Depending on the features you will choose to install you will have to configure the Windows Firewall for SQL Server use
  
  • Open port 1433 if you installed a default installation
    
  • Open port 2383 if you installed OLAP Services
    
  • Open port 80 if you installed Reporting Services
    
  • Additional configuration can be found on the Security Considerations for a SQL Server Installation page
    
    

Important:

 

• Installing SQL Server 2008 on a domain controller is not recommended
  
• When installing SQL Server 2008 on Windows Server 2008 R2 you have to upgrade it to service pack 1 before use.
  

Version numbers:

 

SQL Server 2008 RTM: 10.0.1600.22

SQL Server 2008 SP1: 10.0.2531