Renaming workstations using Offline Ticket Entry

I recently worked with a customer who had their Offline Ticket Entry (OLTE) stop updating.  When investigating the cause, I found that they had renamed the workstation that was running OLTE.  While changing the name to something more meaningful within their network structure made sense, OLTE immediately quit communicating with the server.

The ultimate reason for this, turned out to be that CP-Services is using the internal SQL server name.  Since this name was set in SQL when SQL Server installed, it was the original name of the workstation.  So, when CP-Services started the process of synchronizing with the main server, it was attempting to connect to a SQL server at the original workstation name, which of course did not exist.

In this case the resolution was simple enough, in changing the internal server name with SQL Server on the workstation.  However, this does point out how a seeming innocuous change in one area, can throw other parts of your system into a tailspin.  The best course of action, before changing anything within your network, is to fully research and evaluate the system, or systems, that you propose to change.  Identify any software that could possibly be affected, and the role that software plays in your organization.  Then, once that change is made, test all of those pieces of software to make sure they are still operating as desired.

Remember that CCS Retail Systems Technical Support is always available to help you.  You can reach us at our support department or 800-672-4806.

Dave.

Leave a Reply