|
Home > Archive > BizTalk Server > 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
| |
| Jack Blalock 2004-12-08, 5:50 pm |
| Was the remote SQL machine's MSSQL service restarted after the change? This
has to be done.
Jack Blalock [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.
| |
|
| When I run the dtctester application I get this;
C:\DTCTester>dtctester.exe myodbc user password
Executed: dtctester.exe
DSN: myodbc
User Name: user
Password: password
tablename= #dtc28388
Creating Temp Table for Testing: #dtc28388
Warning: No Columns in Result Set From Executing: 'create table #dtc28388
(ival
int)'
Initializing DTC
Beginning DTC Transaction
Enlisting Connection in Transaction
Error:
SQLSTATE=25S12,Native error=-2147168219,msg='[Microsoft][ODBC SQL Server
Driver]
Distributed transaction error'
Error:
SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid
cur
sor state
Typical Errors in DTC Output When
a. Firewall Has Ports Closed
-OR-
b. Bad WINS/DNS entries
-OR-
c. Misconfigured network
-OR-
d. Misconfigured SQL Server machine that has multiple netcards.
Aborting DTC Transaction
Releasing DTC Interface Pointers
Successfully Released pTransaction Pointer.
C:\DTCTester>
The machine has been rebooted since those changes have been made, we checked
the WINS/DNS config, the remote SQL server does not have multiple nics, we
are running this all behind a firewall.
I have even uninstalled MSDTC by going into the \Windows\System32\ and
running msdtc -uninstall and then rebooting it and running msdtc -install
Anything else that we should be looking for?
Thanks for your assistance...
"Jack Blalock" <jackbl@online.microsoft.com> wrote in message
news:h12BCvT3EHA.2732@cpmsftngxa10.phx.gbl...
> Was the remote SQL machine's MSSQL service restarted after the change?
This
> has to be done.
>
> Jack Blalock [MSFT]
> This posting is provided "AS IS", with no warranties, and confers no
rights.
>
| |
| Alan Smith 2004-12-09, 5:48 pm |
| Hi Eric,
Here's what worked for me:
(Both Boxes).
Application Server:
Enable networkCOM+ access
Enable network DTC acess.
(Both Boxes).
Component Services/MyComputer/MSDTC/Security Configuration:
Checked:
Network DTC Access
Network Administration
Network Transactions
Network Clients
XA Transactions
(ITP Transactions is unchecked).
It took a while to get it sorted, and I'm not sure if it's the best
configuration, but it seems to work. There may also be other issues if your
boxes are sitting in different domains.
Hope it helps.
Alan
"Eric" wrote:
> 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
>
>
>
| |
|
| I ran into the same error message problem using TCP/IP as the tranport
mechanism and it turned out that with DTS the network names didn't
resolve in both directions.
To see if you have this problem, try using "ping" from the command line
of each server to see if the network names resolve properly.
I solved my problem by adding an entry in the SQL server
\system32\drivers\etc\hosts. file to fixup the name resolution problem
going back to the BT server.
Hope this helps,
Mark
|
|
|
|
|