Client Server Pre-Requisite Overview

Before any client installations can take place you should ensure that the appropriate environment is available and that you attend to each of the following items. You should work through the pre-requisite checklist below to ensure that you achieve a successful installation or alternatively you can run the Client Server pre-checker which will do an automatic pre-install check.

System Requirements

  • The minimum operating systems supported is: Windows server 2008 R2 64 bit.
  • SQL Server 2008 (any edition).
  • Microsoft .NET framework 3.5 is a necessary requirement and must be installed. This is required even if you have .NET framework 4 and above installed already.
  • The server that will be used for the Conductor4SQL Client server must have network connectivity, to communicate with the Central Server.
  • The user performing the installation must be in the sys-admin user role in SQL Server.

Mandatory TCP Ports

The following ports are mandatory for the successful installation and operation of Conductor4SQL. Use the Windows Firewall Advanced Security tool and activate the inbound rules for the following ports:

  • Conductor4SQL port 4321
  • SQL Browser – UDP port 1434 (for named instances)
  • SQL Server Administration – TCP port 1433

Warning

If you are using named instances, SQL Server assigns each instance a random port between 49152 and 65535.

Either a firewall rule will needed for this whole range or the instance of SQL Server needs to be configured to use a static port.

Authentication

  • Mixed-Mode authentication must be enabled in Microsoft SQL Server (if you have configured Conductor4SQL to use SQL Authentication)
  • A username with sys-admin role is required

SQL Server services

If you wish to use Enterprise Data Sync with this client the "SQL Server Agent (MSSQLSERVER)" must be set to start automatically