As said earlier, RPC error is not related to the Application. It is related to SQL Server Configuration Settings. The problem will not appear in SQL version 2008 or above. Providing a Common Script in exl format will not be possible since the Linked server name will differ from one office to the other. Hence, the above solution has to be executed giving the Server name in place of 'myserver' -- The above solution was provided by Microsoft only for SQL versions below 2008 for RPC error. Otherwise, Please try with the option -- Administrative tools-- Services-- 'Remote Procedure Call (RPC) ', Remote Procedure Call (RPC) Locator in Services--Set the Startup type as "Automatic" and Log on As "Network service", as shown in the attachment.