Dashboard Designer is the only component that communicates directly not only with the ProcessRobot Server, but also with the SQL Server.
The machine on which the Dashboard Designer is installed, should be able to communicate with the machine of the SQL Server.
The following steps should be followed in order to achieve the above:
- An Inbound Rule on the firewall of the SQL Server machine has to be created, so as to be able to accept requests from the Dashboard Designer machine.
- The TCP/IP protocol for SQLEXPRESS in the SQL Server Network Configuration (C:\Windows\SysWOW64 and run SQLServerManager13.msc) should be set to "Enabled".