Linkes Server MSDTC Error & Windows Server 2003

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 Development (2000)

Linkes Server MSDTC Error & Windows Server 2003

Author

Topic

DBADave
Constraint Violating Yak Guru

366 Posts

Posted - 2006-03-03 : 13:22:22

I'm receiving the following error:

Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].
The transaction active in this session has been committed or aborted by another session.

I've read the information at the following links:

http://support.microsoft.com/default.aspx?scid=kb;en-us;329332

http://support.microsoft.com/?id=817064

Neither worked.

My configuration is Windows Server 2003 SP1 and SQL Server 2000 SE SP3a.

I was able to get the linked server statement to work if I select "No Authentication Required" under "Transaction Manager Communication" within MSTDC of Component Services. However the "No Authentication Required" scares me a bit.

Here's my code.

CREATE TABLE [dbo].[Email] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[Originator] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Date Received] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Recipients] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CC List] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[BCC List] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Subject] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Message] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Unread] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Attachments] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Message ID] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Type] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

Insert Into Email
Exec SQL6.master.dbo.xp_readmail @peek='true', @suppress_attach='true'
GO

Any thougths?

Thanks, Dave

karuna
Aged Yak Warrior

582 Posts

Posted - 2006-03-03 : 15:18:20

Did you tried with mapped logins?

Thanks

Karunakaran

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources