August 6, 2005 at 11:48 am
Hi,
The problem is with MSDTC.
I have two MS SQL 2000 servers (Server1 and Server2) with MS cluster.
There is a linked server in Server1 pointing to Server2.
I would like to copy data from server2 to server1 using linked server and a job.
When i run the query insert into XXX from Select * from <linked server>.<DB nane>.dbo.<table name>, the following message comes in the query analyzer
:
Server: Msg 8501, Level 16, State 3, Line 1
MSDTC on server 'USORICLQSQL01' is unavailable.
"USORICLQSQL01 is vitual sql node in server1"
I also see the following message in sql log:
"Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b"
But when just run Select * from <linked server>.<DB nane>.dbo.<table name>, it works fine. The MSDTC is running in both servers.
Thanks,
Gops
August 9, 2005 at 8:00 am
This was removed by the editor as SPAM
August 13, 2005 at 8:27 am
On what OS are the sql servers operating?
There might be some issue with the new features (rpc security) msdtc got with windows 2003.
According to this site, it is because sqlserver service was started before MSDTC did
http://www.chriskempster.com/tipsandhints.html
August 15, 2005 at 7:50 am
Hi,
Thanks for your reply.
SQL servers on WIN 2003.
Is it the problem is with MSDTC and SQL Service configuration in MS CLuster?
August 15, 2005 at 12:40 pm
Hello,
I've got no experience with clusters yet.
But there is an article in MS knowlegdebase that discusses how msdtc should be configured on a win 2003 cluster
http://support.microsoft.com/default.aspx?scid=kb;en-us;301600
perhaps you need this document too
http://support.microsoft.com/default.aspx?scid=kb;en-us;294209&sd=tech
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply