eCounterlinkserver Login time out expired issues in Speed Net

In SQL 2005 or Higher version while transfer SPCOD it may show the error message like Linked server "eCounterLinkServer" returned message "Login timeout expired".

Solution

Never Create eCounterLinkServer with your own SQL query because it have login credential to access the above mentioned linked server.
Delete eCounter Link Server  then
  1. Execute POSPCC_COD_14082014.exl which provided in Speed Net 4.2 to create the eCounterLinkServer. or
  2. Download eCounterLinkServer Creator to create linked Server.

Download