DTC Error

Hi all,
I built an ASP.Net application. The asp .net application uses distributed
transactions. I add "Transaction='Required'" for every data processing pages
and use "ContextUtil.SetComplete()" or "ContextUtil.SetAbort()" to commit or
abort the transaction.
When the IIS Server and SQL Server are on the same machine, this is no
problem. But when the
IIS server and SQL server are on different machines, error will occurs and
saying that "DTC can not support remote/network transactions".
How the solve this problem?
Thanks!
Kevin
If you are running Win2K3, DTC is disabled for network access by default.
Check out:
How to enable network DTC access in Windows Server 2003
http://support.microsoft.com/default...b;en-us;817064
Good luck.
Anthony Thomas

"Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
news:einMubSJFHA.2736@.TK2MSFTNGP09.phx.gbl...
Hi all,
I built an ASP.Net application. The asp .net application uses distributed
transactions. I add "Transaction='Required'" for every data processing pages
and use "ContextUtil.SetComplete()" or "ContextUtil.SetAbort()" to commit or
abort the transaction.
When the IIS Server and SQL Server are on the same machine, this is no
problem. But when the
IIS server and SQL server are on different machines, error will occurs and
saying that "DTC can not support remote/network transactions".
How the solve this problem?
Thanks!
Kevin
|||Thanks Thomas,
Actually I have already installed Network DTC.
The IIS Machine is WindowsXP, the SQL machine is Windows2003, the two
machines belong to different domain. Do I need to setup something?
Thanks
Kevin
"Anthony Thomas" <ALThomas@.kc.rr.com> д?:u9Kfi4SJFHA.2980@.TK2MSFTNGP10.phx.gbl ...
> If you are running Win2K3, DTC is disabled for network access by default.
> Check out:
> How to enable network DTC access in Windows Server 2003
> http://support.microsoft.com/default...b;en-us;817064
> Good luck.
> Anthony Thomas
>
> --
> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
> news:einMubSJFHA.2736@.TK2MSFTNGP09.phx.gbl...
> Hi all,
> I built an ASP.Net application. The asp .net application uses distributed
> transactions. I add "Transaction='Required'" for every data processing
> pages
> and use "ContextUtil.SetComplete()" or "ContextUtil.SetAbort()" to commit
> or
> abort the transaction.
> When the IIS Server and SQL Server are on the same machine, this is no
> problem. But when the
> IIS server and SQL server are on different machines, error will occurs and
> saying that "DTC can not support remote/network transactions".
> How the solve this problem?
> Thanks!
> Kevin
>
|||That little piece of info would have been helpful.
Here is a way to handle non-domain communication.
HOWTO: Enable DTC Between Web Servers and SQL Servers Running Windows Server
2003
http://www.support.microsoft.com/?kbid=555017&SD=tech
I know I've seen articles on how to set this up between two different
domains, same forest and different forests, but can't find it at the moment.
However, the following may prove useful to you as well,
How To Troubleshoot MS DTC Firewall Issues
http://support.microsoft.com/default...b;en-us;306843
Good luck.
Anthony Thomas

"Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
news:Oe7mPtUJFHA.1172@.TK2MSFTNGP12.phx.gbl...
Thanks Thomas,
Actually I have already installed Network DTC.
The IIS Machine is WindowsXP, the SQL machine is Windows2003, the two
machines belong to different domain. Do I need to setup something?
Thanks
Kevin
"Anthony Thomas" <ALThomas@.kc.rr.com>
д?:u9Kfi4SJFHA.2980@.TK2MSFTNGP10.phx.gbl ...
> If you are running Win2K3, DTC is disabled for network access by default.
> Check out:
> How to enable network DTC access in Windows Server 2003
> http://support.microsoft.com/default...b;en-us;817064
> Good luck.
> Anthony Thomas
>
> --
> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
> news:einMubSJFHA.2736@.TK2MSFTNGP09.phx.gbl...
> Hi all,
> I built an ASP.Net application. The asp .net application uses distributed
> transactions. I add "Transaction='Required'" for every data processing
> pages
> and use "ContextUtil.SetComplete()" or "ContextUtil.SetAbort()" to commit
> or
> abort the transaction.
> When the IIS Server and SQL Server are on the same machine, this is no
> problem. But when the
> IIS server and SQL server are on different machines, error will occurs and
> saying that "DTC can not support remote/network transactions".
> How the solve this problem?
> Thanks!
> Kevin
>
|||Thomas,
Thanks for your reply, I solved my problems!
Kevin
"Anthony Thomas" <ALThomas@.kc.rr.com> д?:%230JYHoXJFHA.3596@.TK2MSFTNGP14.phx.g bl...
> That little piece of info would have been helpful.
> Here is a way to handle non-domain communication.
> HOWTO: Enable DTC Between Web Servers and SQL Servers Running Windows
> Server
> 2003
> http://www.support.microsoft.com/?kbid=555017&SD=tech
> I know I've seen articles on how to set this up between two different
> domains, same forest and different forests, but can't find it at the
> moment.
> However, the following may prove useful to you as well,
> How To Troubleshoot MS DTC Firewall Issues
> http://support.microsoft.com/default...b;en-us;306843
> Good luck.
> Anthony Thomas
>
> --
> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
> news:Oe7mPtUJFHA.1172@.TK2MSFTNGP12.phx.gbl...
> Thanks Thomas,
> Actually I have already installed Network DTC.
> The IIS Machine is WindowsXP, the SQL machine is Windows2003, the two
> machines belong to different domain. Do I need to setup something?
> Thanks
> Kevin
>
> "Anthony Thomas" <ALThomas@.kc.rr.com>
> д?:u9Kfi4SJFHA.2980@.TK2MSFTNGP10.phx.gbl ...
>
|||Want to share. I'm curious how you solved it.
Thanks.
Anthony Thomas

"Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
news:uYQjZDeJFHA.484@.TK2MSFTNGP15.phx.gbl...
Thomas,
Thanks for your reply, I solved my problems!
Kevin
"Anthony Thomas" <ALThomas@.kc.rr.com>
д?:%230JYHoXJFHA.3596@.TK2MSFTNGP14.phx.g bl...
> That little piece of info would have been helpful.
> Here is a way to handle non-domain communication.
> HOWTO: Enable DTC Between Web Servers and SQL Servers Running Windows
> Server
> 2003
> http://www.support.microsoft.com/?kbid=555017&SD=tech
> I know I've seen articles on how to set this up between two different
> domains, same forest and different forests, but can't find it at the
> moment.
> However, the following may prove useful to you as well,
> How To Troubleshoot MS DTC Firewall Issues
> http://support.microsoft.com/default...b;en-us;306843
> Good luck.
> Anthony Thomas
>
> --
> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
> news:Oe7mPtUJFHA.1172@.TK2MSFTNGP12.phx.gbl...
> Thanks Thomas,
> Actually I have already installed Network DTC.
> The IIS Machine is WindowsXP, the SQL machine is Windows2003, the two
> machines belong to different domain. Do I need to setup something?
> Thanks
> Kevin
>
> "Anthony Thomas" <ALThomas@.kc.rr.com>
> д?:u9Kfi4SJFHA.2980@.TK2MSFTNGP10.phx.gbl ...
>
|||Hi Thomas,
I add the following registry values, set the firewall to allow ports form
5000~5020 & 135, and then restart both computers.
Ports : REG_MULTI-SZ : 5000-5020
PortsInternetAvailable : REG_SZ : Y
UseInternetPorts : REG_SZ : Y
These information are all in the articals you have mentioned.
Kevin
"Anthony Thomas" <ALThomas@.kc.rr.com> д?:O7pSP6jJFHA.3484@.TK2MSFTNGP12.phx.gbl ...
> Want to share. I'm curious how you solved it.
> Thanks.
> Anthony Thomas
>
> --
> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
> news:uYQjZDeJFHA.484@.TK2MSFTNGP15.phx.gbl...
> Thomas,
> Thanks for your reply, I solved my problems!
>
> Kevin
> "Anthony Thomas" <ALThomas@.kc.rr.com>
> д?:%230JYHoXJFHA.3596@.TK2MSFTNGP14.phx.g bl...
>