Prev: BCP
Next: newbie-sys.dm_db_index_physical_stats
From: Snezana on 13 Jan 2010 16:37
Hi,

We have migrated our db from sql2000 win server 2k to sql2008 win server 2k8.
We have linked server from sql2000 win server 2k. By our opinion the problem
is with DTC and we have made a lot of setting that we found as solution for
our problem, but still the problem exist. There is no any error or worning or
information niether in the sql log nor in win event viewer. The application
is hanging out and at the end the time out exception is shown.

What we have done till now:

1. Enable Network DTC Access with inbound and outbound with No Authentication
Required on win 2k8
2. We have opened RPC dynamic port allocation through registry on 2k and 2k8
3. We have entered subkey TurnOffRpcSecurity in the registry
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC and made it enable on 2k and 2k8
4. We have added exception for DTC in firewall for all entities

What we have notice that when we restart SQL service and make the first try
for our transaction the following is shown:
"Attempting to initialize Microsoft Distributed Transaction Coordinator (MS
DTC). This is an informational message only. No user action is required."
and after it:
"Recovery of any in-doubt distributed transactions involving Microsoft
Distributed Transaction Coordinator (MS DTC) has completed. This is an
informational message only. No user action is required."

Does someone have any idea what else can be done in order to solve the
problem?

Thanks in advance.

Regards,
Snezana

From: Snezana on 13 Jan 2010 22:42
Snezana wrote:
>Hi,
>
>We have migrated our db from sql2000 win server 2k to sql2008 win server 2k8.
>We have linked server from sql2000 win server 2k. By our opinion the problem
>is with DTC and we have made a lot of setting that we found as solution for
>our problem, but still the problem exist. There is no any error or worning or
>information niether in the sql log nor in win event viewer. The application
>is hanging out and at the end the time out exception is shown.
>
>What we have done till now:
>
>1. Enable Network DTC Access with inbound and outbound with No Authentication
>Required on win 2k8
>2. We have opened RPC dynamic port allocation through registry on 2k and 2k8
>3. We have entered subkey TurnOffRpcSecurity in the registry
>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC and made it enable on 2k and 2k8
>4. We have added exception for DTC in firewall for all entities
>
>What we have notice that when we restart SQL service and make the first try
>for our transaction the following is shown:
>"Attempting to initialize Microsoft Distributed Transaction Coordinator (MS
>DTC). This is an informational message only. No user action is required."
>and after it:
>"Recovery of any in-doubt distributed transactions involving Microsoft
>Distributed Transaction Coordinator (MS DTC) has completed. This is an
>informational message only. No user action is required."
>
>Does someone have any idea what else can be done in order to solve the
>problem?
>
>Thanks in advance.
>
>Regards,
>Snezana

Hi,

Also, I would add that we have tried to execute the query:

begin distributed tran

exec linkedserver.linkdb.storeprocedure


commit tran

and it is working.

And also on another places where we have transaction on linked server is is
working. And sometimes it is happening the targeted place to pass and there
is no rule when that will be.

Any idea what else to check?

 | 
Pages: 1
Prev: BCP
Next: newbie-sys.dm_db_index_physical_stats