In PCM600 2.10 and later, SQL Server and PCM600 can be installed on different computers. The server computer contains SQL Server and a shared location where PCM600 stores internal files. The client PC contains PCM600, Update Manager and connectivity packages. PCM600 installer can perform client or server installation. For installation instructions, see PCM600 Installation Guide.
When using the distributed setup, each user using PCM600 must have access to SQL Server. This is done by adding the user to the PCMSERVER2014 Users user group. The user group is automatically created after installing PCM600 on the server computer.
If no domain account is used, an account with the same name and password must exist on both the client and the server machine.
The server machine must share the directory defined by the %PCMDATADIRABB% system environment variable and the PCMSERVER2014 Users user group must be given full privileges to that directory. If the name “PCMDataBasesABB” is given to the share, the client automatically has the correct path in PCMDATADIRABB system environment variable after the client installation.
If the server machine has firewall, it needs to allow communication to two ports.
| Port | Description |
|---|---|
| 1434/UDP | SQL Browser service |
| 1435/TCP by default | SQL Server |
The server uses the SQL Browser service to tell the client which port the server is listening to. The SQL Server port can be changed using SQL Server Configuration Manager.