Follow

Installation Prerequisites

The installation program for SQL Server offers to install the appropriate versions of the Microsoft .NET Framework and Windows Installer if they are not already installed. You must install these components to proceed with the installation of SQL Server, and you must restart your server when prompted after these components are installed.
If the TEAMserver and SQL Server will be running on the same machine, it doesn't matter if the Windows Firewall rule is not Passed. If they will run on different machines, you will need to ensure that the Windows Firewall is configured to allow connections from the TEAMserver, so that the TEAMserver will be able to connect to the SQL Server.
Your installation media may not have the option to install the Management Tools, but they can be downloaded and installed separately.

Installation Prerequisites

This section describes how to install and configure the prerequisite software required for TEAMserver.

Installing Internet Information Services

Before you can install TEAMserver, you must install Internet Information Services (IIS) with the options that the installation procedures specify. After you install IIS, you should install any recommended updates from Microsoft using Windows Update. To find out how to install IIS, select the version of Windows you are going to install IIS in, below:

Installing IIS 6.0 on Windows Server 2003 Installing IIS 7.0 on Windows Server 2008 Installing IIS 7.0 on Windows Server 2012 Installing IIS 7.0 on Windows Server 2016
       

On servers that are running Windows Server 2003 or Windows Server 2003 R2, you can use Control Panel to install Internet Information Services (IIS) 6.0. In addition to the default options, you must configure IIS 6.0 with these options:

  • ASP.NET must be enabled.
  • The IIS 5.0 isolation option must not be enabled.

Required Permissions

To perform this procedure, you must be a member of the Administrators security group on the server on which you are installing IIS.

To install IIS on Windows Server 2003

  1. Open Add or Remove Programs from Control Panel.
  2. Click Add/Remove Windows Components.
    The Windows Components Wizard starts.
  3. On the Windows Components page, select the Application Server checkbox, and then click Details.
  4. If not already selected, select the ASP.NET checkbox, and then click OK. Do not change or clear any other currently selected components.
  5. On the Windows Components page, click Next.
  6. Click Finish to close the wizard.

On servers that are running Windows Server 2008, you can use the Server Manager to install Internet Information Services (IIS) 7.0. In addition to the default options, you must add the following role services to IIS 7.0:

  • ASP.NET
  • IIS 6.0 Management Compatibility

Required Permissions

To perform this procedure, you must be a member of the Administrators security group on the application-tier server.

To install IIS 7.0 on Windows Server 2008

  1. On the server where you intend to install TEAMserver, click Start, point to Administrative Tools, and then click Server Manager.
  2. In the tree pane, click Roles.
  3. In the details pane, click Add Roles. The Add Roles Wizard starts.
  4. On the Before You Begin page, read the instructions, and then click Next.
  5. On the Select Server Roles page, select the Web Server (IIS) checkbox. If the Add features required for Web Server (IIS) dialog box appears, click Add Required Features. Click Next.
  6. On the Web Server (IIS) page, read the information, and then click Next.
  7. On the Select Role Services page, select the following checkboxes (without changing the other default settings):
    • ASP.NET
      If the Add role services and features required for ASP.NET dialog box appears, click Add Required Role Services.
    • Windows Authentication
    • IIS 6 Management Compatibility
      All subordinate checkboxes are automatically selected.
    and then click Next.
  8. On the Confirm Installation Selections page, review the installation information.
  9. If the information is correct, click Install. To make corrections, click Previous.
  10. After the Add Roles Wizard installs IIS, click Close.

Required Permissions

To perform this procedure, you must be a member of the Administrators security group on the application-tier server.

Installing IIS 7.0 on Windows Server 2012

  1. On the server where you intend to install TEAMserver, open the Server Manager. You can do this by clicking on the icon in the Taskbar, or by searching for it in the Start Screen.
  2. In the Server Manager window, click Add Roles and Features.
  3. The Add Roles and Features Wizard opens.
  4. On the Before You Begin page, read the instructions, and then click Next.
  5. In the Installation Type page, ensure that the option Role-based or feature-based installation option is enabled. Then click Next.
  6. In the Server Selection page, ensure that Select Server from the server pool is enabled, and then select the current computer from the pool.
  7. Click Next.
  8. On the Select Server Roles page, select the Web Server (IIS) checkbox.

    If the Add features required for Web Server (IIS) dialog box appears, click Add Features.

    Click Next.
  9. In the Select Features page, select:
    • .NET FrameWork 3.5 Features.
    • ASP.NET 4.5, which is under the .NET FrameWork 4.5 Features.
    • HTTP Activation, which is under WCF Services.

    If the Add features required for HTTP Activation dialog box appears, click Add Features.
    Click Next.
  10. In the Web Server Role (IIS) page, read the information, then click Next.
  11. On the Select Role Services page, select the following checkboxes (without changing the other default settings), and then click Next:
    • Windows Authentication
    • IIS 6 Management Compatibility; make sure to select IIS 6 Management Console, which is under IIS 6 Management Compatibility.

    Click Next
  12. On the Confirm Installation Selections page, review the installation information. If the information is correct, click Install. To make corrections, click Previous.
  13. After the Add Roles Wizard finishes installing IIS, click Close.

Required Permissions

To perform this procedure, you must be a member of the Administrators security group on the application-tier server.

Installing IIS 7.0 on Windows Server 2016

  1. On the server where you intend to install TEAMserver, open the Server Manager. You can do this by clicking on the icon in the Taskbar, or by searching for it in the Start Screen.
  2. In the Server Manager window, click Add Roles and Features.
  3. The Add Roles and Features Wizard opens.
  4. On the Before You Begin page, read the instructions, and then click Next >.
  5. In the Select Installation Type page, make sure that the option Role-based or feature-based installation option is enabled. Then click Next >.
  6. In the Select destination server page, ensure that Select Server from the server pool is enabled, and then select the current computer from the pool.
  7. Click Next >.
  8. On the Select Server Roles page, select the Web Server (IIS) checkbox.

    If the Add features required for Web Server (IIS) dialog box appears, click Add Features.

    Click Next.
  9. In the Select Features page, select:
    • .NET FrameWork 3.5 Features. To be able to install this, you will need to provide a source for the .NET FrameWork 3.5. If you do not have a source available, there is another way to install .NET FrameWork 3.5 in Windows Server 2016.
    • ASP.NET 4.6, which is under the .NET FrameWork 4.6 Features.
    • HTTP Activation, which is under WCF Services.

    If the Add features required for HTTP Activation dialog box appears, click Add Features.

    Click Next >.
  10. In the Web Server Role (IIS) page, read the information, then click Next >.
  11. On the Select Role Services page, select the following checkboxes (without changing the other default settings), and then click Next:
    • Windows Authentication
    • IIS 6 Management Compatibility; make sure to select IIS 6 Management Console, which is under IIS 6 Management Compatibility.

    Click Next >
  12. On the Confirm Installation Selections page, review the installation information. If the information is correct, click Install. To make corrections, click < Previous.
  13. After the Add Roles Wizard finishes installing IIS, click Close.

Installing SQL Server

Before you install TEAMserver, you must install Microsoft SQL Server or have an existing installation of SQL Server that meets the following requirements:

Supported Editions
  • Microsoft SQL Server 2005
  • Microsoft SQL Server 2008
  • Microsoft SQL Server 2012
  • Microsoft SQL Server 2014
  • Microsoft SQL Server 2016
  • Microsoft SQL Server 2017
  • Microsoft SQL Server 2019
Collation Settings
  • Must be accent sensitive
  • Must not be case sensitive
  • Must not be Binary
  • Must not be Binary - code point
Authentication Windows authentication
Service account You can use a domain account or a built-in account

For instructions on how to install SQL Server, click on the version of SQL Server you are going to install, below:

Installing SQL Server 2005 Installing SQL Server 2008 Installing SQL Server 2014 to 2019
     

The following instructions will guide you through the process of installing and configuring the features of SQL Server 2005 Standard or Enterprise Edition required to run TEAMserver. If you intend to use the same SQL Server installation to serve other applications, you may want to install additional features.

Required Permissions

To perform these procedures, you must be a member of the Administrators security group on the server on which you are installing SQL Server. If you have opted for a single-server deployment, this will be the same server on which you install TEAMserver.

To Install SQL Server 2005

  1. Log on to Windows using an appropriate account.
  2. Start the installation wizard by inserting the installation DVD for SQL Server 2005 Enterprise Edition or Standard Edition.
    The SQL Server 2005 Start page appears.
  3. On the SQL Server 2005 Start page, click Server components, tools, Books Online, and samples.
  4. On the End User License Agreement page, review the license agreement. If you accept the terms and conditions, select the I accept the licensing terms and conditions checkbox, and then click Next.
  5. On the Installing Prerequisites page, click Install.
  6. After the prerequisites are installed, click Next.
    The Microsoft SQL Server Installation Wizard starts.
  7. Click Next.
  8. On the System Configuration Check page, perform any required actions, such as restarting the server, and then click Next to start installation.
    Note: For a dual-server deployment, you can safely ignore the warning about installing Internet Information Services (IIS) on the server running SQL Server.
  9. On the Registration Information page, complete the registration information, and then click Next.
  10. On the Components to Install page, select the checkbox for SQL Server Database Services, then click Next.
  11. On the Instance Name page, click Default instance or Named instance. If you click Named instance, type the name of the instance. Click Next.
  12. On the Service Account page, click Use the built-in System account or Use a domain user account. If you click Use the built-in System account, select Network Service. If you click Use a domain user account, type a domain account and password. In Start services at the end of setup, select the following checkboxes, and then click Next:
    • SQL Server
    • SQL Server Agent
    • SQL Browser
  13. On the Authentication Mode page, click Windows Authentication Mode, and then click Next.
  14. On the Collation Settings page, select the appropriate collation for the languages you will be using, and then click Next.
    Note: TEAMserver requires certain collation settings. You should select a collation that is not case sensitive, accent sensitive, not binary and preferably not width and kana sensitive.
  15. (Optional.) On the Error and Usage Reporting page, select one or both checkboxes to specify where information about errors and feature usage should be sent, and then click Next.
  16. On the Ready to Install page, review the list of components to be installed, and then click Install.
    The Setup Progress page shows the installation status of each component.
  17. After installation has completed, click Next.
  18. Click Finish to close the wizard.

The following instructions will guide you through the process of installing and configuring the features of SQL Server 2008 Standard or Enterprise Edition required to run TEAMserver. If you intend to use the same SQL Server installation to serve other applications, you may want to install additional features.

Required Permissions

To perform these procedures, you must be a member of the Administrators security group on the server on which you are installing SQL Server. If you have opted for a single-server deployment, this will be the same server on which you install TEAMserver.

To install SQL Server 2008

  1. Log on to Windows using an appropriate account.
  2. Insert the installation DVD for SQL Server 2008 Enterprise Edition or Standard Edition and double-click setup.exe.
    Note: The installation program for SQL Server offers to install the appropriate versions of the Microsoft .NET Framework and Windows Installer if they are not already installed. You must install these components to proceed with the installation of SQL Server, and you must restart your server when prompted after these components are installed.
  3. On the SQL Server Installation Center page, click Installation, and then click New SQL Server stand-alone installation or add features to an existing installation.
  4. On the Setup Support Rules page, click OK.
  5. On the Product Key page, type your product key.
  6. On the License Terms page, review the license agreement. If you accept the terms and conditions, select the I accept the licensing terms checkbox, and then click Next.
  7. On the Setup Support Files page, click Install.
  8. On the Setup Support Rules page, click Next.
  9. On the Feature Selection page, select the checkbox for Database Engine Services, and then click Next.
  10. On the Instance Configuration page, click Default instance or Named instance. If you click Named instance, type the name of the instance. Click Next.
  11. On the Disk Space Requirements page, click Next.
  12. On the Server Configuration page, click Use the same account for all SQL Server services, or type the name of a domain account or NT AUTHORITY\NETWORK SERVICE in Account Name for every service.
    • If you specify a domain account, type its password in Password.
    • If you use NT AUTHORITY\NETWORK SERVICE, leave the Password box blank.
    In the Startup Type column, verify that Automatic appears for all accounts that you can edit.
  13. In the Collation tab, select the appropriate collation for the language you will be using, and then click Next.
    Note: TEAMserver requires certain collation settings. You should select a collation that is notcase sensitive, accent sensitive, not binary and preferably not width and kana sensitive.
  14. On the Database Engine Configuration page, click Windows authentication mode, click Add Current User, and then click Next.
  15. (Optional.) On the Error and Usage Reporting page, select one or both checkboxes to specify where information about errors and feature usage should be sent, and then click Next.
  16. On the Installation Rules page, click Next.
  17. On the Ready to Install page, review the list of components to be installed, and then click Install.
    The Installation Progress page shows the status of each component.
  18. After installation has completed, click Next.
  19. On the Complete page, click Close.

The following instructions will guide you through the process of installing and configuring the features of SQL Server Standard or Enterprise Edition required to run TEAMserver. If you intend to use the same SQL Server installation to serve other applications, you may want to install additional features.

Required Permissions

To perform these procedures, you must be a member of the Administrators security group on the server on which you are installing SQL Server. If you have opted for a single-server deployment, this will be the same server on which you install TEAMserver.

To install SQL Server 2014 or 2016

  1. Log on to Windows using an appropriate account.
  2. Insert the installation DVD for SQL Server Enterprise Edition or Standard Edition, and double-click Setup.exenote.
  3. On the SQL Server Installation Center page, click Installation, and then click New SQL Server stand-alone installation or add features to an existing installation.
  4. The SQL Server Setup wizard starts.
  5. On the Product Key page, type your product key.

    Then click Next.
  6. On the License Terms page, review the license agreement. If you accept the terms and conditions, select the I accept the licensing terms checkbox, and then click Next.
  7. Check the check-box Use Microsoft Update to check for updates (recommended). Then click Next.
  8. If the Product Updates page appears, wait for it to finish finding updates, then click Next.
  9. The Wizard will run various checks to ensure that the SQL Server will work correctly after installing. The Install Rules page will show you a report to warn you of potential problems. If all the Rules are labelled Passednote, click Next.
  10. If the Setup Role page appears, select SQL Server Feature Installation and then click Next.
  11. On the Feature Selection page, select the checkbox for Database Engine Services. You can optionally select Management Tools - Basic and Management Tools - Complete to install various tools that may be useful if you need to manage your SQL Servernote. Then click Next.
  12. On the Instance Configuration page, click Default instance or Named instance. If you click Named instance, type the name of the instance. Click Next.
  13. On the Server Configuration page, click Use the same account for all SQL Server services (if available), or type the name of a domain account or NT AUTHORITY\NETWORK SERVICE into the Account Name field for every service.
    • If you specify a domain account, type its password in Password.
    • If you use NT AUTHORITY\NETWORK SERVICE, leave the Password box blank.
    In the Startup Type column, verify that Automatic appears for all accounts that you can edit.
  14. In the Collation tab, select the appropriate collation for the language you will be using. Be aware that TEAMserver requires certain collation settings. You should select a collation that is:
    • not case sensitive
    • accent sensitive
    • not binary
    • preferably not width and kana sensitive
    Click Next.
  15. On the Database Engine Configuration page, click Windows authentication mode, click Add Current User, and then click Next.
  16. If the Installation Rules page appears, review its content, and click Next.
  17. On the Ready to Install page, review the list of components to be installed, and then click Install.

    The Installation Progress page shows the status of each component.
  18. On the Complete page, check that all the features were successfully installed, then click Close.
< System Requirements - Previous Next - Installing TEAMserver >
Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk