Error when connecting through COM.

From: Abhi (abhijeet@couthit.com)
Date: 03/08/03 

From: "Abhi" <abhijeet@couthit.com>
Date: Sat, 8 Mar 2003 03:22:09 -0800

Plaese help me out to resolve the security problem.
When I try to connect the SQL Server present in another
domain using VB application (ADO), it works fine. But when
I try to connect the SQL Server present in another domain
using COM, it gives following error:

-2147168246: New transaction cannot enlist in the specified
transaction coordinator. -2147168246: New transaction
cannot enlist in the specified transaction coordinator.

Is this because of the domain security or the SQL Server
security. If so, why it allows to connect directly with VB
and not when component used? I have trusts created in both
the domains.

-Abhijeeet D.

Relevant Pages

  • RE: SQL Adapter Issue with more than one machine
    ... It might have something to do with the Distributed Transaction Coordinator. ... You should do this on both machines: BizTalk and SQL Server. ... Restart the MSDTC services on both machines. ... cannot enlist in the specified transaction coordinator. ...
    (microsoft.public.biztalk.general)
  • COM and SQL Server in different domains.
    ... Please help me to resolve the security problem. ... cannot enlist in the specified transaction coordinator ... SQL Server residing in another domain. ...
    (microsoft.public.win2000.security)
  • Re: SQL or Access DB
    ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Is there any way to prevent hacker trying to guess sa password?
    ... and port 1433 will not be open. ... If someone can crash SQL Server by connecting to port 1433, ... You don't need multiple security experts. ...
    (microsoft.public.sqlserver.security)
  • Re: Getting to the bottom of MSDE network connection problems ...
    ... Brilliant, Nick, especially the explanation for local network user being ... authenticated as GUEST in WinXP SP2. ... > on a desktop OS like XP (meaning that, you can not compare SQL Server ... > again and selected the security tab. ...
    (microsoft.public.sqlserver.msde)