Viewing 2 posts - 1 through 2 (of 2 total)
I had this problem between two SQL2005 servers, but your solution does not work for 2005 since
sp_serveroption optname "remote proc transaction promotion" is SQL2008 and up.
Changing the Windows component install...
July 19, 2012 at 10:49 am
#1515003
Restarting the SQL Engine fixed if for me...not that there is an answer there, but it worked.
May 25, 2011 at 2:45 pm
#1329962