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 |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2006-05-18 : 15:06:12
|
| I need to link two servers, myLocal and myRemote, in the same domain. I tried to linke them but failed for two days.Can some one show me how to do it step by step? |
|
|
cmdr_skywalker
Posting Yak Master
159 Posts |
Posted - 2006-05-18 : 20:39:48
|
| Make sure you have a network connection and they are of the latest service pack. Use ping command. If you have connection, make sure that the login you are using is working on both server. See BOL for sp_addlinkedserver requirements. Let us know if you still encounter errors.May the Almighty God bless us all! |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-19 : 03:22:58
|
post the steps you did and we might be able to point out where the discrepancy is... --------------------keeping it simple... |
|
|
|
Sun Foster
Aged Yak Warrior
515 Posts |
Posted - 2006-05-19 : 09:49:13
|
| I got error messages:...unable beging distributed transation...new transation cannot enlist in the specified transation |
|
|
|
Sun Foster
Aged Yak Warrior
515 Posts |
Posted - 2006-05-19 : 09:57:53
|
| I got it!!!http://support.microsoft.com/kb/834849/en-us |
|
|
|
|
|
|
linked server problem