Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This topic describes how to install Microsoft SQL Server 2008. The installation procedure is described in the following sections:

Anchor
_before
_before
Before You Begin Installation

Please review the following important notes before installing Microsoft SQL Server 2008:

  • For server installations, the computer must meet the following minimum software requirements:
    • Windows Server 2003 (SP2) or Windows Server 2008 and up operating system.
       
  • For production systems, install Microsoft SQL Server 2008 Enterprise or Standard, or Workgroup edition. For development environments, you may also use Microsoft SQL Server 2008 Developer edition.
  • Aptify 5.5 and up requires Microsoft SQL Server 2008 and up. The server should not have Microsoft SQL Server 2005 installed.
  • The Aptify installation program uses the collation of the SQL Server when it creates the APTIFY database. However, note that Aptify does not support case-sensitive collations.

Anchor
_sql2008
_sql2008
Installing SQL Server

...

Follow these steps to install SQL Server 2008 on your server before installing Aptify 5.5. Note that the computer must meet the minimum requirements for Microsoft SQL Server 2008 (refer to the Microsoft documentation for details) as well the requirements described in the previous section.

  1. Obtain a copy of the SQL Server 2008 installation media for the version you want to install.
  2. Run the SQL Server setup program.
  3. If prompted, click OK to install the SQL Server 2008 pre-requisites (including Microsoft.NET Framework 3.5 SP1).

    Pre-requisites Notice
     
  4. If applicable, follow the on-screen instructions to install Microsoft .NET Framework 3.5 SP1.
  5. When the .NET Framework installation is complete, install a Microsoft Hot Fix, if prompted. After installing the hot fix, restart the server and re-run the SQL Server 2008 Setup program (per the on-screen instructions).
  6. When the SQL Server Installation Center loads, select the Installation page in the left pane and then select the New SQL Server stand-alone installation or add features to an existing installation option on the right.

    SQL Server Installation Center

  7. The installation processes a set of Setup Support Rules. Review the results of these Setup Support Rules and click OK when finished.

    Specify Product Key
     
  8. When prompted, enter your product key and click Next.
  9. Review and accept the terms of the license and click Next.
  10. Click Install to run the Setup Support Files step. Review any failures. If the process completes without failures, click Next to continue.
  11. Select the SQL Server 2008 features you want to install. At a minimum you should install the Database Engine Services and any management tools you plan to use. Click Next to continue.

    SQL Server Feature Selection
     
  12. Specify the details for this SQL Server instance and click Next to continue.

    Tip

    To simplify the installation of Aptify 5.5 and up, Aptify recommends that you install SQL Server 2008 in the default location on the C: drive as the default instance on the server. If you specify a non-default instance, you will need to direct Aptify to use that path later when you install the Aptify software.



    Specify Instance Details

  13. Review the disk space requirements and click Next to continue.
  14. Specify the Service Accounts that will run the SQL Server services. Consult the Microsoft SQL Server 2008 documentation for more information.

    Specify Service Accounts

  15. Click the Collation tab and specify the collation to use for the server. The Aptify installation program uses the collation of the SQL Server when it creates the APTIFY database. Click Next to continue.

    Tip

    Select a case-insensitive collation only. Aptify does not support case-sensitive collations. If in doubt, use the default collation.



    Collation Setting

  16. On the Account Provisioning tab, select Mixed Mode as the Authentication Mode and enter a password for the sa user.

    Configure SQL Administrators

  17. Add at least one user as a SQL Server administrator. For example, you can click the Add Current User option to add your user as a SQL Server administrator.
  18. Click Next to continue.
  19. If installing the Analysis Services, add at least one user as an administrator and click Next to continue.
  20. Click Next and follow the on-screen instructions to continue the installation.
  21. Click the Install button to begin the installation.
  22. Follow the on-screen instructions to close the Setup program when prompted.
  23. Check the TCP/IP configuration of SQL Server 2008 to confirm that the TCP/IP protocol is enabled. If not, enable it. See Enabling Remote Connectivity for SQL Server 2008 for details.
  24. If installing SQL Server 2008 on a Windows Server 2008 server, configure Windows Firewall to allow incoming SQL Server traffic. See http://msdn.microsoft.com/en-us/library/cc646023.aspx for details.

    Note

    Windows Server 2008's default Firewall settings block incoming SQL server traffic. You need to open the firewall to allow this traffic in order to communicate with the SQL server from an Aptify Desktop client installed on another network computer.