Biztalk Adapters

View :

Show duplicate posts

Distributed Transaction Error - SQL Adapter

All posts: microsoft.public.biztalk.general
Source: microsoft.public.biztalk.general
Sent date: 05/15/2008
From: Roger Hsieh
Message:

Getting this error message in the event viewer -
"HRESULT="0x80040e14" Description="The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction."

My Biztalk server and the database is one server (Server A). The SQL I am running is on a different server (Server B). And in the sql, I have a table that I am calling on another Server C.

Server A is a Windows 2008 Server with SQL Server 2005. Server B is a Windows 2003 Server with SQL Server 2000. And Server C is a Windows 2000 Terminal with SQL 2000.

Now if I leave out the table reference to Server C, the SQL Adapter receiving location works. What property is wrong or missing?

Post Reply

Related Messages

RE: Distributed Transaction Error - SQL Adapter

Sent date: 05/18/2008
From: Roch Baduel
Message:

Hello Roger,
I Think you need to configure MSDTC security to allow inbound / outbound
transactions and perhaps to turn off rpc security (for W2003/SP1
:TurnOffRpcSecurity key in the registry )
take a look at :

http://technet2.microsoft.com/windowsserver/en/library/8fcbafc0-26ff-4091-9dfd-e029d5a1af7d1033.mspx?mfr=true

and

http://msdn.microsoft.com/en-us/library/aa544733.aspx

Hope it helps,

Best regards,
Roch

"Roger Hsieh" wrote:

Show quoted text

> Getting this error message in the event viewer -
> "HRESULT="0x80040e14" Description="The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction."
>
> My Biztalk server and the database is one server (Server A). The SQL I am running is on a different server (Server B). And in the sql, I have a table that I am calling on another Server C.
>
> Server A is a Windows 2008 Server with SQL Server 2005. Server B is a Windows 2003 Server with SQL Server 2000. And Server C is a Windows 2000 Terminal with SQL 2000.
>
> Now if I leave out the table reference to Server C, the SQL Adapter receiving location works. What property is wrong or missing?
>

Other groups

BizTalk BAM, activity

Biztalk Adapters

BizTalk Orchestration

BizTalk Server

WS WSDL



	Recent Jobs A great opportunity to Digital Video Eng here is a greate opportunity as a SMS En A great opportunity as a Network Enginee A Greate Opportunituy as a SQL Developer An immediate job opportunity as a Biztal View all Jobs (Add yours) View all CV (Add yours)
	Information Online
	swimming pool builder chicago web site design conference calls Domain Names conference call service Donna karan sunglasses answering service
	Partners Dream.In.Code dotNet Slackers dotNet Spider Your HTML Source VisualBuilder.com DevGuru Planet Source Code ZVON.ORG Web Design ASPAlliance XML Pitstop Scripts The Spot 4 SAP Bitshop Web Hosting

Email TopXML