Installing PCM600 on SQL Server computer - Software products - Cyber Security Deployment Guideline - PCM600 Protection and Control IED Manager - 2.13 - IEC - ANSI - 28.06.2023

PCM600 Cyber Security Deployment Guideline
  1. Install PCM600 with option Install only SQL Server.
  2. Ensure that all users using PCM600 have a user account (either a domain account or a standard user with the same name and password) on both client and server machines.
  3. Using lusrmgr.msc, add all PCM600 users to the PCMSERVER2014 Users group.
  4. Share the PCMDataBasesABB folder (with full control) with all PCM600 users.
  5. Configure the SQL Server Browser service to start up automatically and start it if it is not running.
  6. Ensure that the firewall allows communication with SQL Server Browser (port UPD 1434).
  7. Configure the port for SQL Server.
    1. Open Sql Server Configuration Manager (using SQLServerManager15.msc).
    2. Enable TCP/IP for PCMSERVER2019ABB.
      Figure 1. Enabling TCP/IP for PCMSERVER2019ABB in Sql Server Configuration Manager

    3. Right-click TCP/IP and select Properties.
    4. On the IP Addresses tab, scroll down to the IPAll section, leave TCP Dynamic Ports empty and specify a port number (for example, 1435) in the TCP Port field.
      Figure 2. Defining a port number for SQL Server

      Note: If Distributed PCM600 installation is created using IP addresses and not with computer names, locate the IP Address for your SQL Server and set Enabled to "Yes".
    5. Allow inbound TCP communication to the selected port in the Windows firewall for SQL Server. The executable file is usually C:\Program Files\Microsoft SQL Server\MSSQL15.PCMSERVER2019ABB\MSSQL\Binn\sqlservr.exe.