Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
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 19:38pm
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)

  Print Answers RSS
0 Zoltán Zörgő 220
1 Peter Leow 160
2 CPallini 120
3 BillWoodruff 85
4 bling 80
0 Sergey Alexandrovich Kryukov 9,428
1 OriginalGriff 6,901
2 Peter Leow 4,737
3 Zoltán Zörgő 4,349
4 CHill60 2,932

Advertise | Privacy | Mobile
Web04 | 2.8.150129.1 | Last Updated 21 Feb 2012
Copyright © CodeProject, 1999-2015
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