1.3 Installing PlateSpin Protect Software Components

This section provides information on installing the required components included in the PlateSpin Protect software. In order to use a remote Microsoft SQL Server database server and environment (instead of installing the SQL Server software included with the product on the same server), you must configure settings for the SQL server and configure your environment to allow the remote connection.

1.3.1 Before You Install PlateSpin Protect

Ensure that your intended PlateSpin Server host meets the following prerequisites:

Choose the appropriate database server option:

1.3.2 Downloading PlateSpin Protect Installation Program

  1. Download the PlateSpinProtectSetup-11.2.1.xxxx.exe installation program from the PlateSpin Protect download page:

    1. Go to Micro Focus Downloads.

    2. Select PlateSpin Protect from the Browse by Product list, or type the product name in the Browse by Product field to find the product and then select it.

    3. On the Download overview page, click proceed to download, then log in with your customer account credentials.

    4. Click accept to acknowledge and agree to the U.S. Export Laws and Regulations.

    5. On the Download page, click download next to the PlateSpinProtectSetup-11.2.1.xxxx.exe file, then save the file.

  2. Copy the downloaded file to an accessible location on your intended PlateSpin Server host.

1.3.3 Installing the Database Server

Use one of the following methods to set up the database server before you install PlateSpin Protect:

Installing Microsoft SQL Server Express Edition

If you do not have an existing Microsoft SQL Server database server, you can install the Microsoft SQL Server Express Edition included in your PlateSpin Protect software distribution.

NOTE:The Microsoft SQL Server Express Edition included with PlateSpin Protect Server cannot be installed on a domain controller in accordance with Microsoft Developer Network recommendations.

To install Microsoft SQL Server Express:

  1. On your intended database server host, start the Installation Launcher.

    See Downloading PlateSpin Protect Installation Program.

  2. Click Install SQL Server Express and follow the on-screen instructions.

    The program installs a database server and the database instance required for the operation of PlateSpin Protect.

    NOTE:The SQL administrator password is generated during the installation of Microsoft SQL Server Express Edition. Keep the default sa credentials throughout the PlateSpin Protect Server installation. After the installation is complete, you should modify the SQL administrator password. See Section 1.5, Modifying the Password for the SQL Server Express System Administrator User.

  3. (Conditional) If your SQL Server database server is on a separate server than the one you plan to use for the PlateSpin Server, configure the settings in your environment to allow the remote connection. See Configuring Your Remote Microsoft SQL Server Database Server.

Configuring Your Remote Microsoft SQL Server Database Server

In order for your existing Microsoft SQL Server installation to function properly, PlateSpin Protect requires that you configure specific settings in your environment before you install the product. These settings allow the remote connection between your SQL Server and PlateSpin Server.

To prepare your existing SQL server:

  1. Ensure that your database server is running a supported version of Microsoft SQL Server. See Database Server.

  2. Ensure that you have a dedicated, named database instance to use with PlateSpin Protect. You need the database server name and database instance name during the product installation.

    NOTE:You can use the same Microsoft SQL Server database server to host database instances for multiple PlateSpin Protect and PlateSpin Migrate servers. Each database instance must be uniquely named and configured separately for its PlateSpin Server.

  3. Ensure that you configure Microsoft SQL Server to allow both TCP/IP and Named Pipe connections.

  4. (Conditional) If you plan to use Windows Authentication to access the Microsoft SQL Server database, you must configure the following in Active Directory:

    • You must add the Microsoft SQL Server database server to the domain.

    • You need two domain user accounts for the PlateSpin Protect installation.

      • A Domain user with the sysadmin role set: This user with SQL Admin rights is required to create databases, tables, and other schema objects.

      • PlateSpin Service user: The service user can be a low-privileged domain user in the domain. However, the service user must be a local administrator on the PlateSpin Protect Server and should be granted that permission prior to the installation.

        If the Windows user’s password changes, you must update the password for the PlateSpin Service user and for the IIS App Pool. Consider using a Windows user whose password never expires to avoid the situation.

    NOTE:If you use Windows Authentication, you must log in as the domain user with SQL Admin rights when you upgrade or update your PlateSpin Server.

  5. Open the following ports on the firewall to support authentication to the SQL Server:

    • Ports 49152-65535/TCP: Allow traffic for RPC for LSA, SAM, Netlogon.

    • Port 1433/TCP: Allow traffic for Microsoft SQL Server.

    • Custom ports: If you configure SQL Server to use a custom TCP port, you must open that port on the firewall.

    NOTE:If you do not use dynamic ports, you must specify the dedicated port in the Database Server field.

  6. (Conditional) If you want to use dedicated ports with PlateSpin Protect, you must open the ports on the firewall:

    1. On the database server, determine which ports need to be opened:

      1. In the SQL Server Configuration Manager, select Protocols for SQLExpress > TCP/IP, then right-click and select Properties.

      2. In the dialog, select the IP Addresses tab.

      3. Under IPAll (or under the desired protocol), if TCP Port or TCP Dynamic Ports is set to any value other than 0, open the specified ports on the firewall. These are the ports you use to connect to the SQL Server.

        For example, if the TCP Dynamic Ports field is set to 60664, and the TCP Port field is set to 1555, then you must enable Port 60664 and 1555 in the firewall rules on the SQL server.

    2. Open the ports on the firewall.

    NOTE:If you have a value set for dynamic ports, you may not see your server in the list of SQL servers when you click Browse. In this case, you must specify the server manually in the Database Server input field of the PlateSpin Protect installation.

    For example, if your server name is MYSQLSERVER, the database instance name SQLEXPRESS, and the dedicated port set for the dynamic port is 60664, you type the following text, and then select the desired authentication type:

    MYSQLSERVER\SQLEXPRESS,60664

    You must open the ports on the firewall.

1.3.4 Installing the PlateSpin Server

After you set up the target database server, you are ready to install PlateSpin Server.

  1. On your intended PlateSpin Server host, start the Installation Launcher.

    If the installation program detects an existing local installation of SQL Server, it disables the corresponding Install SQL Server Express option.

  2. In the PlateSpin Protect Installation Launcher, click Install PlateSpin Server.

  3. Read the software license agreement, select the I accept the terms in the license agreement option, then click Next.

    You must accept the software license agreement before installing the product.

  4. Specify a location for the temporary setup files, then click Next.

  5. Specify a database server and database instance. Do one of the following:

    • If you are using the database server included in your PlateSpin Protect software distribution installed locally (the default option), leave the default selection (local)\PLATESPINDB in the drop-down list and leave the default sa credentials.

      If you subsequently move your PlateSpin Protect database instance or change your SQL Server password, you must reset the PlateSpin Protect database connection settings. For more information, see Knowledgebase Article 7970523.

    • If you are using a remote database server, click Browse to select from a list of available database servers in the network. Specify the database in the following format:

      • Single-instance SQL Server installations: database_server

      • Multiple-instance SQL Server installations: database_server\database_instance (specify the instance name)

  6. Specify your database credentials for the specified database server, then click Validate Server to validate them.

    (The default settings are SQL Server: (local)PLATESPINDB) and SQL Logon: sa.)

  7. Click Next and verify your SQL Instance and SQL Logon selections.

  8. Click Next.

  9. The installation program prompts you specify whether you want to allow HTTP or HTTPS:

    • If you require secured connections (HTTPS), leave the option deselected (default).

      If your IIS server has a signed SSL certificate, the default communication protocol will be HTTPS; if not, your browser will display a warning about an “untrusted connection.” This is normal. For information on how to proceed, see your browser documentation.

    • If you require unsecured connections (HTTP), select the Allow unsecured connections (HTTP) option.

  10. Click Next, verify the installation settings, then click Install and follow the on-screen instructions.

    The installation program installs the PlateSpin Server software and prepares it to run.

    NOTE:This process might take several minutes to complete.