July 18, 2006 at 8:05 am
OK, this may not be a SQL issue, but getting the error thrunthe application.
Communication with the underlying transaction manager has failed.
I have tried everthing that I know of......starting DTC, RPC services, making sure that the passwords work across link servers, all the usual communication stuff.....etc.
Anyone have any ideas?
July 19, 2006 at 3:59 am
The linked server issue seems to be a known bug when a 64 bit SQL 2005 client tries to access a SQL Server 2000 database server.
The resolution is explained in the MS support document
http://support.microsoft.com/default.aspx?scid=kb;en-us;906954
Hope this helps.
July 19, 2006 at 8:48 am
First, run the query through SMS to get better error messages. There are several potential issues, including the one Frank talks of.
Terry
July 21, 2006 at 8:01 am
Thanks to all.
The servers are all 2005, so the MS fix didnt work. By the way, I did have that issue on some of my other machines and the fix works wonderfully.
I took Terry's suggestion and was able to get the procedure to work. But it still failed in the application. I also made the procedure do nothing but "PRINT 'Hello World!" and it still failed......
It turned out that the issue was in the .net application, and required some configuration changes there.
Thanks again to all.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply