Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-06-26 : 12:48:52
|
| Dear Experts,we've server1 with windows 2003 server sql server 2000(32bit)we've server3 with windows 2003 server sql server 2000(32bit)we've server2 with windows 2003 server sql server 2005(64bit)i've configured linked server between these two. my requirement is i need the data from server1 to server2.i'm getting the data from server3 to server2 as the both servers are in same domain.but i'm unable to get the data from server1 to server2 as server1 is in different domain. ofcource that is in dual domain(i mean that server is pinging from server2. and i'm able to connect to server1 through SSMS. is there anything need to do to get the data from server1? please help me in this regard.one more doubt....can i take the data from server2(64bit) to server1(32bit)? will it accept to run insert statement through linked server?i think i've given sufficient information.please help me here.i'm getting the error (communication link failed).also saying that authentication failed for server2(while i'm trying to take the data from server1 from server2).thanks in advanceArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-26 : 13:47:56
|
| First of all, its confusing.Did you setup Linked server in Server2 for server 1 using Same SQL Aunthentication? You can use Export/Import wizard to transfer data from one server to other server. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-28 : 23:13:15
|
| Map user to standard sql login on linked server when you create linked server. |
|
|
|
|
|
|
unable to get records from linked server