Re: Query performance

Wei,

1) I'm doing a transaction against SQL 2005 (and only SQL 2005) so the DTC
is not involved. The exception/error is generated by the LTM not the DTC.
I have seen DTC errors before and they are different.

2) Yes the DTC security is configured for Network Access, Allow Remote
Clients, Mutual Authentication, Enable TIP, Enable XA Transactions.

Why would connecting with SSMS enable transactional code to work - is there
any way (logs etc) to diagnose this problem?

Regards
Phil Lee

"Wei Lu" <weilu@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:iFHlWYrYGHA.1232@xxxxxxxxxxxxxxxxxxxxxxxx
Hi Phil,
Thanks for the update.

I would like to know are you using Distribute Transcation. If so, I think
you should also configure the DTC security in your SQL 2005 Server.

Please do the following to enable DTC in your server and client.

RAN dcomcnfg -> Component Service -> Computers - My Computer - >
Properties
->
MSDTC -> Security Configuration -> Network DTC ACCESS.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.



.

Relevant Pages

  • Re: Transactions and updating two or more MS SQL servers
    ... you'll need to use the DTC. ... > I have a connection set up in the VFP application for each server, ... > I enclose the data updates on each server within Begin Transaction / ... > Commit Transaction pair. ...
    (microsoft.public.fox.vfp.queries-sql)
  • Problems with Win2K3 - DTC and winmgmt in Event Viewer
    ... single CPU server for awhile, ... MSDTC ... Could not start the MS DTC Transaction Manager ...
    (microsoft.public.windows.server.general)
  • Re: LeaseTime can only be set once within an AppDomain.
    ... Visual Studio 2003 only - when I am trying to deploy to my own BizTalk Server ... I have re-installed MSDTC and set the appropriate values in the DTC ... To enable network DTC access and network COM+ access in Windows Server 2003 ...
    (microsoft.public.biztalk.general)
  • Re: LeaseTime can only be set once within an AppDomain.
    ... It's from the "Installing and Configuring BizTalk Server in a Multicomputer ... Considerations for Using Distributed Transaction Coordinator ... you must enable network DTC access and network ...
    (microsoft.public.biztalk.general)
  • Re: COM+/DTC + firewall + SQL Server = need help
    ... Configuring Microsoft Distributed Transaction Coordinator (DTC) to ... Since you are only using one SQL Server, why are you using COM+ distributed ... If you have no need for a distributed transaction stop using transactions ...
    (microsoft.public.sqlserver.security)
Loading