| Use4Forums 2006-01-23, 6:02 pm |
| hi,
I am getting the following error while I am trying to generate a schema
using the SQL Adapter comes with BizTalk 2004:
"Failed to execute SQL Statement. Please ensure that the supplied
syntax is correct. An error occurred while enlisting in a distributed
transaction."
The platform info and something I have tested out:
1. VPC image with Win2003/BTS2004 installed and running. A couple of
other BizTalk solution are running fine in this VPC environment.
2.The MSDTC setting on the VPC OS, following the installation Notes you
provided. (Checked Network DTC Access; Allow Remote Clients; Allow
Inbound & Outbound; No Authentication Required; Enable Transaction
Internet Protocol Transaction. DTC Login Account is "NT
Authority\NetworkService."
3. The remote SQL 2005 Server has the same MSDTC setting.
4. SQL Adapter uses SQL 2005 account, which has DB.OWNER privilege to
the database I am connecting to.
5. The Stored procedure was running fine on SQL05 server itself.
6. I was able to do the same thing on VPC local SQL2K server using
Northwind, but not the remote SQL2K.
Below is the testing Stored Procedure in SQL 2005 server. I am aware
that the document indicating that I need to remove the XMLDATA out of
FOR XML clause.
CREATE PROCEDURE [dbo].[testSLQ05]
AS
BEGIN
SET NOCOUNT ON;
SELECT CustomerID, CustomerName, OrderID
FROM CustomerOrder
FOR XML AUTO, XMLDATA
END
Do I miss anything? Your help would be highly appreciated.
Thx,
|