|
Home > Archive > BizTalk Server General > February 2005 > SQL Adapter
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| I am trying to use the SQL adapter to place data in a remote database, when
I run the data through biztalk, in the Event Viewer, I get the following
error message; The adapter "SQL" raised an error message. Details "New
transaction cannot enlist in the specified transaction coordinator. ".
I can insert the data on the Biztalk Server's local database, but not a
remote SQL server.
Things I have done;
1. In Add/Remove Programs, I have verified that Enable DTC access (found in
Application Server) is checked on both machines
2. In Administrative Tools/ Component Services, under the properties of 'My
Computer' in Security Configuration in Security Settings all boxes are
checked, and the DTC Logon Account is; NT AUTHORITY\NetworkService on both
machines
3. They are both under the same workgroup, and in the SQL Enterprise
Manager, I can view the contents of the remote database.
They both are running Windows 2003, SQL Server 2000 with SP3. The remote
machine does NOT have SQLXML 3.0, is that the problem?
Thanks for your assistance.
Eric
| |
| Doug Girard [MSFT] 2005-02-22, 5:50 pm |
| Hi Eric,
I understand you've enabled DTC access on both machines, but is Microsoft
Distributed Transaction Coordinator (MSDTC) enabled for network
transactions on both machines?
The following article may also be of some assistance:
http://support.microsoft.com/Default.aspx?kbid=873160
HTH,
Doug Girard [MSFT]
Note: This posting is provided "AS IS" with no warranties, and confers no
rights.
--------------------
>From: "Eric" <ericstott.dnsme@hotmail.com>
>Subject: SQL Adapter
>Date: Mon, 6 Dec 2004 13:35:02 -0700
>Lines: 26
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.3790.181
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181
>Message-ID: <u0bOUM92EHA.2540@TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.biztalk.general
>NNTP-Posting-Host: VDSL-130-13-183-214.PHNX.QWEST.NET 130.13.183.214
>Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09
.phx.gbl
>Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.general:22276
>X-Tomcat-NG: microsoft.public.biztalk.general
>
>I am trying to use the SQL adapter to place data in a remote database, when
>I run the data through biztalk, in the Event Viewer, I get the following
>error message; The adapter "SQL" raised an error message. Details "New
>transaction cannot enlist in the specified transaction coordinator. ".
>
>I can insert the data on the Biztalk Server's local database, but not a
>remote SQL server.
>
>Things I have done;
>1. In Add/Remove Programs, I have verified that Enable DTC access (found in
>Application Server) is checked on both machines
>2. In Administrative Tools/ Component Services, under the properties of 'My
>Computer' in Security Configuration in Security Settings all boxes are
>checked, and the DTC Logon Account is; NT AUTHORITY\NetworkService on both
>machines
>3. They are both under the same workgroup, and in the SQL Enterprise
>Manager, I can view the contents of the remote database.
>
>They both are running Windows 2003, SQL Server 2000 with SP3. The remote
>machine does NOT have SQLXML 3.0, is that the problem?
>
>Thanks for your assistance.
>
>Eric
>
>
>
| |
| Doug Girard [MSFT] 2005-02-22, 5:50 pm |
| Eric,
This is a great KB article which should also help you in troubleshooting
your DTC problems.
http://support.microsoft.com/?kbid=306843
HTH,
Doug Girard [MSFT]
Note: This posting is provided "AS IS" with no warranties, and confers no
rights.
--------------------
>From: "Eric" <ericstott.dnsme@hotmail.com>
>Subject: SQL Adapter
>Date: Mon, 6 Dec 2004 13:35:02 -0700
>Lines: 26
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.3790.181
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181
>Message-ID: <u0bOUM92EHA.2540@TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.biztalk.general
>NNTP-Posting-Host: VDSL-130-13-183-214.PHNX.QWEST.NET 130.13.183.214
>Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09
.phx.gbl
>Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.general:22276
>X-Tomcat-NG: microsoft.public.biztalk.general
>
>I am trying to use the SQL adapter to place data in a remote database, when
>I run the data through biztalk, in the Event Viewer, I get the following
>error message; The adapter "SQL" raised an error message. Details "New
>transaction cannot enlist in the specified transaction coordinator. ".
>
>I can insert the data on the Biztalk Server's local database, but not a
>remote SQL server.
>
>Things I have done;
>1. In Add/Remove Programs, I have verified that Enable DTC access (found in
>Application Server) is checked on both machines
>2. In Administrative Tools/ Component Services, under the properties of 'My
>Computer' in Security Configuration in Security Settings all boxes are
>checked, and the DTC Logon Account is; NT AUTHORITY\NetworkService on both
>machines
>3. They are both under the same workgroup, and in the SQL Enterprise
>Manager, I can view the contents of the remote database.
>
>They both are running Windows 2003, SQL Server 2000 with SP3. The remote
>machine does NOT have SQLXML 3.0, is that the problem?
>
>Thanks for your assistance.
>
>Eric
>
>
>
| |
| Niklas E 2005-02-27, 5:52 pm |
| Here are some other DTC trouble-shooting which I have gathered:
http://bizspace.blogspot.com/
Best regards
Niklas Engfelt
""Doug Girard [MSFT]"" <dogirard@online.microsoft.com> wrote in message
news:GnweATRGFHA.400@TK2MSFTNGXA02.phx.gbl...
> Eric,
>
> This is a great KB article which should also help you in troubleshooting
> your DTC problems.
> http://support.microsoft.com/?kbid=306843
>
> HTH,
> Doug Girard [MSFT]
>
> Note: This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> --------------------
> cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09
> phx.gbl
>
|
|
|
|
|