Re: SQL adapter

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Please open Component Services, My Computer, Properties, MSDTC, Security
Configuration configure the following options

Network DTC Access
Allow Remote Clients

Allow Inbound
Allow Outbound
No Authentication Required

Enable XA Transactiond

This configuration must be done on the SQL Server Box.

Good luck

Mateus Morato Fantini


"Henk" <Henk@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0CAD4A76-0254-4145-B884-1F1D58E50B57@xxxxxxxxxxxxxxxx
Thanks for your replies guys,
devMonkey: my machine is on XP with biztalk and the other sql server is on
windows server 2003
Eliasen: I did exactly what you suggested, but unfortunately no succes
Fantini: I already downloaded this paper and have done the different
options.

After shutting down the windows firewall and my virus program (no virus
program on the remote windows server 2003) and stopping the firewall
service
on the windows server, the tool dtcping from my XP machine is working, but
I
keep getting the error from the windows server: "Problem:fail to invoke
remote RPC method Error(0x5) at dtcping.cpp @303 -->RPC pinging exception
-->5(Access is denied.) RPC test failed"

We really would like to know if any of you would know other options.
Regards
Henk

"Henk" wrote:

We are getting error: "failed to execute SQL statement. Please ensure the
supplied syntax is correct. New transaction cannot enlist in the
specified
transaction coordinator".
We googled and got tons of suggestions. Basicly we found a white paper
from
MS "Best practices for the sql adapter". We have done exactly what is
written
to no avail. However running the dtcPing tool gives us error: "1753(There
are
no more endpoints available from the endpoint mapper.)
RPC test failed".
We have opened for inbound and outbound on MSDTC on both sides. We have
no
firewall and antivirus. We are out of options. Does anyone have any
clues?


.

Relevant Pages

  • Re: 4 forests-domains, roaming clients, no trusts, not Internet-Ba
    ... "Windows Server 2003 and Cross Forest Site Communications ... Communications across forests work in Configuration Manager 2007 if the ... Account appears to be for Client to Server communication. ...
    (microsoft.public.sms.setup)
  • Re: Printer Admin Object
    ... and ports on local and remote computers. ... Add and delete a local or remote printer. ... Instrumentation scripts in Windows Server 2003, ... -- torgeir, Microsoft MVP Scripting and WMI, Porsgrunn Norway Administration scripting examples and an ONLINE version of the 1328 page Scripting Guide: ...
    (microsoft.public.scripting.vbscript)
  • Re: Cluster in IBM Bladecenter HS20
    ... > HS20 blades in the following way. ... > then you public network). ... What is the correct LAN configuration? ... >> configuration is certified by the Windows Server Catalog. ...
    (microsoft.public.windows.server.clustering)
  • Re: batch file queries
    ... Using PrinterAdmin with a Visual Basic Script ... and ports on local and remote computers. ... Add and delete a local or remote printer. ... Instrumentation scripts in Windows Server 2003, ...
    (microsoft.public.windowsxp.general)
  • Re: OpenSSH server on Windows Server 2003?
    ... I prefer using SSH to administrate remote machines but have recently started working with Windows Server 2003. ... I use this package just for the SFTP options that it gives me as I was unable find a method of securely transferring files to a Windows server that was flexible enough for my needs. ... This will also give you a command line prompt remotely, but using this option for remote administration may not be ideal because many of the configuration interfaces for windows applications are not available on the command line. ...
    (microsoft.public.windows.server.general)