SQL Server Performance Forum – Threads Archive
New transaction cannot enlistI am trying to link to MSDE server. I am getting this error The operation could not be performed because the OLE DB provider ‘SQLOLEDB’ was unable to begin a distributed transaction. OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. I am running SQL Server 2000 SP4 on Windows 2000 SP4.
Insert and Delete are working fine in Query Analyser. But they fail in Trigger —————————————-
Firstly make sure both servers can resolve each others names and ping each other. They must resolve just the machine name not fqdn. If they can then it’s probably a security issue. Open up components Services in the Adminitrators Tools – in My Computer Properties select the MSDTC tab. Under Security configuration make sure the Network DTC Access box is checked. If you’re still stuck check teh MSDTC registry keys under HKLM. I’ve found tinkering with these can help – just don’t play with teh IsDomainController (or similar option). If you still stuck now then download from MS as tool called DTCPing. It will test your network and configuration. Hope this helps.
Thanks for the reply
I ried with ping each other and they are not resolving by their names. My admin saying that it cann;t be done. So we have to find out other way of doign this Thanks again for the reply —————————————-
If your DNS doesn’t allow for this try putting manual entries in the hosts file (C:WindowsSystem32DriversEtc). This will work unless you are on dynamic ip’s. Simon
We did that but no success —————————————-