sp_cop is down in sp_ctrl in Windows environment (4259878)

sp_cop is down in sp_ctrl in Windows environment

Customer start up shareplex from SpUtils as non-administrator. sp_cop is down within sp_ctrl:

sp_ctrl > port 2200
Communication failure - sp_cop is no longer running

The problem is when sp_ctrl connects to cop, cop will spawn a cnc process. The cnc process tries to get a temporary file and it gets a NULL pointer. It tries to access the null pointer and core dumps. The cause of getting the NULL pointer is that the TMP variable isnt set for the user running shareplex as a service. A problem is that the environment variables used by a service wont get changed until the system is rebooted. They need to set the environment variable for the user that shareplex is running as in the service and reboot the system.

RESOLUTION 1:
As a temporary measure the customer can run cop from the command line that has the TMP variable set correctly and use the command:
sp_copsrv -debug -r<port_number></port_number>

RESOLUTION 2:
Start up shareplex as local administrator from SpUtils