Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
Hi,
 
my apps was created here in manila, everything went well, even the testings with 5 PC and 3 db servers went very well.
 
on installation abroad, it work well, but gathering data from another   or remote server gives a error "cannot establish connection with linked server",
 
I tried doing PING the remote server and i'm connected.
 
i checked with the linked servers under server objects in ssms and the remote server is listed, i even did server registration but still the same error pops in my apps. i'm a connecting that remote server via VPN, thus this give the error? that i'm trying to establish a connection on a VP network.
Posted 20-Feb-12 18:38pm
Comments
Edward Nutting at 21-Feb-12 2:21am
   
Giving an exact error message/error code/error number would probably help people answer this - at the moment it could be almost anything!
Arun Ashok at 21-Feb-12 6:47am
   
Is your DB is SQL Server, then try this on your two remote server query window.
 
sp_addlinkedserver 'servername'
Alan Tuscano at 21-Feb-12 7:52am
   
Hi Arun,
 
Yes, its SQL Server 2005. in my testing, i've installed in SSMS to 5 pc to test sp_addlinkedserver, it executed successfully, run my apps, worked okay.. i switched from server to server just to verify if the linked server is doing okay.. and its doing very good, even testing my apps.
 
I tried doing sp_linkedserver in the pc where i test my apps.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Advertise | Privacy | Mobile
Web02 | 2.8.140821.2 | Last Updated 21 Feb 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100