MSDTC on server 'Server_name' is unavailable.

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

MSDTC on server 'Server_name' is unavailable.

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-06-08 : 07:56:26

Dejan writes "I have stand-alone instance of MS SQL Server in cluster environment. I want to insert rows from 'table1' wich is part of DatabaseName1 (cluster) to DatabaseName2..table2 (stand-alone):

insert into ServerName2.DatabaseName2.dbo.table2
select * from ServerName1.DatabaseName1.dbo.table1

and answer is: MSDTC on server 'ServerName1' is unavailable.

But, if I do this:

select * into #tmp from ServerName1.DatabaseName1.dbo.table1

insert into ServerName2.DatabaseName2.dbo.table2
select * from #tmp

it works.

Any explanations ?"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-06-08 : 12:14:21

So is the Distributed Transaction Coordinator service started on both servers? Do you have linked servers setup?

Tara

dejjan
Yak Posting Veteran

99 Posts

Posted - 2004-06-09 : 05:31:16

DTC service was started on both servers. I ran sp_addlinkedserver procedure to input new server in sysservers.

Dejan Jankovic
[database administrator]

ALCO banka A.D.
Beograd
Pozeska 65b
11030 Beograd
tel: [+381][11] 30 50 383
mob: [+381][64] 11 022 48

leahsmart
Posting Yak Master

133 Posts

Posted - 2004-06-29 : 05:02:13

I have got the same problem MSDTC on server unavailable. I can run a simple select statement fine over my linked servers but I cannot get it to run an update or insert statement. What do I do?

Kristen
Test

22859 Posts

Posted - 2004-06-29 : 09:48:25

I forgot to mention the #TEMP_TABLE workaround in the other thread, is that an option for you too?

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources