SPEED NET 4.2 RUN-TIME ERROR : SP COD TRANSFER TO MEGHDOOT POSTMAN

Speed Net Issues With Transfer SPCOD To Postman

While Transfer SPCOD articles in Speed Net 4.2 it shows an error message as "could not find server 'eCounterLinkServer' in a sysservers. Execute sp_addlinkedserver to add the server to sysservers"

Solution Received From CEPT

The article data for SP-COD is transferred from Speednet Server to Meghdoot Server based on the linked server concept and the prerequisites for creation of linked server are that the Meghdoot server should have the remote connections enabled.

To configure SQL Server 2005 to allow remote connections, you must complete these steps:

1. Enable remote connections on the instance of SQL Server that you want to connect to from a remote computer.
2. Turn on the SQL Server Browser service.
3. Configure the firewall to allow network traffic that is related to SQL Server and to the SQL Server Browser service.
4. To enable remote connections on the instance of SQL Server 2005 and to turn on the SQL Server Browser service, use the SQL Server 2005 Surface Area Configuration tool. The Surface Area Configuration tool is installed when you install SQL Server 2005.

You can view further information athttp://support.microsoft.com/kb/914277.

You can google for similar information for other versions of SQL Server. For some versions, enabling of the Named Pipes and TCP/IP options under the Surface Area Configuration setting for SQL Server might be required to be done additionally. 

Once the above configurations are done, please re-execute the POSPCC_COD_14082014.exl script and check.