|
Home > Archive > BizTalk Server Applications Integration > December 2004 > 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
| |
| Anthony O 2004-12-08, 5:50 pm |
| Eric,
You may want to use a DTCping to verify that you can actually run DTC between the two systems.
This may be a firewall issue or it may be a name resolution issue.
See my previous posting on this issue.
Anthony O.
"Eric" <ericstott.dnsme@hotmail.com> wrote in message news:ey%23jFM92EHA.1408@TK2MSFTNGP10.phx.gbl...
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 2004-12-22, 2:46 am |
| You migth want to try the DTCTester as well, which solved my problems. I
didn't find the problems with the DTCPing tool.
http://support.microsoft.com/defaul...b;EN-US;Q293799
If you have a firewall. Be sure to set the ports manually else it will take
random ports which your firewall won't handle. I set my ports to 5000-5199
on both servers and opened them in the firewall which solved my problems. I
also set the RPCSecurityOff (or similar) setting to off in the registry on
both servers.
If you have a cluster, the DTC service will fail to start in a standard
installation because the start order of the services in the cluster are
wrong in a default installation. You need to manually change that order to
cluster the DTC service. Or if you install COM+ 1.5 rollup package 3 or
Windows 2003 sp1 when it is released.
Best regards
Niklas Engfelt
"Anthony O" <anthonyodole@yahoo.com> wrote in message
news:Oabj0bW3EHA.524@TK2MSFTNGP09.phx.gbl...
Eric,
You may want to use a DTCping to verify that you can actually run DTC
between the two systems.
This may be a firewall issue or it may be a name resolution issue.
See my previous posting on this issue.
Anthony O.
"Eric" <ericstott.dnsme@hotmail.com> wrote in message
news:ey%23jFM92EHA.1408@TK2MSFTNGP10.phx.gbl...
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
|
|
|
|
|