Introduction

The step-by-step installation of Microsoft SQL Server 2008 is described in this document.

Description

Prerequisite

Before beginning the installation process, check the following prerequisites:

• Ensure the computer meets the system requirements outlined in this document.

   

• Make sure you have administrator's rights on the computer where Microsoft SQL Server 2008 (SQL Server 2008) will be installed.

   

• Back up Exact Globe's database on the SQL Server.

   

• Verify that the disk where SQL Server 2008 is to be installed is uncompressed. If you attempt to install SQL Server 2008 to a compressed drive, setup will fail.

   

• Exit your antivirus software while installing SQL Server 2008.

   

• Stop all services that depend on SQL Server, including any service using Open Database Connectivity (ODBC) such as Internet Information Services (IIS). Exit Event Viewer and registry editors (Regedit.exe or Regedt32.exe).

   

Once these prerequisites are met, proceed to install SQL Server 2008.

Installation

1. Insert the SQL Server installation media. From the root folder, double-click Setup.exe. If the SQL Server 2008 Setup dialog box appears, click OK to install the prerequisites, then click Cancel to exit SQL Server 2008 installation.
    
2. If you do not have Microsoft .Net Framework 3.5 SP1 installed, the installer will display the following message to install the Microsoft .Net Framework 3.5 SP1. Click OK to proceed.
   
   
    
3. Windows Installer 4.5 is also required. The following message will be displayed if it is not available. Click  OK to proceed. If you are prompted to restart your computer, restart it, and then restart SQL Server 2008 Setup.exe.
   
   
    
4. Click Installation to create a new installation SQL Server 2008.
   
   
   
   
5. Select New SQL Server stand-alone installation or add features to an existing installation to proceed.
   
   
    
6. The Setup Support Rules screen is displayed. Click OK to proceed after the scanning is done.
   
   
    
7. Enter the product key and click Next to proceed.
   
   
    
8. Select the I accept the license terms check box and click Next to proceed.
   
   
   
   
9. Click Install to proceed.
   
   
    
10. Click Next to connect.
    
     
    
    Note: You will receive a warning on the Windows Firewall. This is normal as, by default, Windows has blocked the TCP port. You can refer to http://msdn.microsoft.com/en-us/library/ms175043.aspx to learn how to enable the TCP port later.
     
11. If you do not need the extra features provided by SQL Server 2008, you can just choose the following features:
    • Instance Features -> Database Engine Services
    • Share Features -> SQL Server Books Online
    • Share Features -> Management Tools Basic
    • Share Features -> Management Tools Basic -> Management Tools - Complete
    • Full-Text Search: If you want to use the SQL full text search for searching feeds in the timeline of Exact Synergy Enterprise, this component should be selected. If you have not selected this component during the installation of the SQL Server, you can install it at a later time. For more information, see Defining social collaboration settings.
      
    Click Next to proceed.
    
    
     
12. Select Default instance if you do not have any SQL Server instance installed or select Named instance if you have an existing SQL Server installed. Click Next to proceed.
    
    
     
13. Click Next to proceed.
    
    
     
14. Click on the "Account Name" column for SQL Server Agent and SQL Server Database Engine services and select NT AUTHORITY\SYSTEM. Click Next to proceed.
    
    Note: If you do not want to use the system's default Regional Setting for language, you will need to select the collation that you want to install by clicking the Collation tab to adjust it yourself.
    
    
     
15. Select "Mixed Mode (SQL Server authentication and Windows authentication)" and enter the password for system administrator. Click Add Current User to set yourself as the SQL Server administrator. Click Next to proceed.
    
      
     
16. Select the Error and Usage Reporting option to specify the information that you want to send to Microsoft that will help improve SQL Server. Click Next to proceed.
    
    
     
17. Click Next to proceed.
    
    
     
18. Click Install to proceed.
    
    
     
19. It will take some time to install SQL Server 2008. Click Next to proceed after the installation.
    
    
     
20. Click Close to exit the setup after the installation.
    
    
     
21. Click X at the top right corner to close the SQL Server Installation Center.
    
    

Related document

• MSDN - How to: Install SQL Server 2008 (Setup)
• Upgrading to Microsoft SQL Server 2008