| Author |
Error - A DTC problem prevented connection to the configuration database
|
|
|
| Hi Everyone,
We are trying to set up BT2004 Release version on a two
machine configuration. Windows 2003 Standard for BizTalk
and Win2K for SQL2000. When I do the configuration, I am
getting the following error:
Failed to deploy BizTalk system aseembly "{installation
directory}\Microsoft.BizTalk.GlobalPrpertySchemas.dll"
A Microsoft distributed transaction soordinator problem
preveted connection to the configuration database.
The transaction has already been inplicitly or explicitly
committed or aborted.
[Microsoft.BizTalk.Deployment.DeploymentException] Cannot
open database BizTalkMgmtDb on server ...
Please help. Thank You.
| |
| John Plummer [MSFT] 2004-03-25, 5:00 pm |
| Goto Component Services / My Computer / Properties / MSDTC Tab / Security
Configuration and Enable Network DTC Access
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"AJMR" <anonymous@discussions.microsoft.com> wrote in message
news:1371301c412ab$eedf84b0$a301280a@phx
.gbl...
Hi Everyone,
We are trying to set up BT2004 Release version on a two
machine configuration. Windows 2003 Standard for BizTalk
and Win2K for SQL2000. When I do the configuration, I am
getting the following error:
Failed to deploy BizTalk system aseembly "{installation
directory}\Microsoft.BizTalk.GlobalPrpertySchemas.dll"
A Microsoft distributed transaction soordinator problem
preveted connection to the configuration database.
The transaction has already been inplicitly or explicitly
committed or aborted.
[Microsoft.BizTalk.Deployment.DeploymentException] Cannot
open database BizTalkMgmtDb on server ...
Please help. Thank You.
| |
|
| John,
Thanks for your quick reponse. I tried that it but it
still does not work. Network Admin, Transactions and
client checkboxes are on under Network DTC access.
Also I am using domain groups and accounts with domain
biztalk admin accounted added as the local admin on the
BizTalk machine. Please advise.
Thanks in advance for your help.
AJMR
>-----Original Message-----
>Goto Component Services / My Computer / Properties /
MSDTC Tab / Security
>Configuration and Enable Network DTC Access
>
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>Use of included script samples are subject to the terms
specified at
>http://www.microsoft.com/info/cpyright.htm
>
>
>"AJMR" <anonymous@discussions.microsoft.com> wrote in
message
> news:1371301c412ab$eedf84b0$a301280a@phx
.gbl...
>Hi Everyone,
>
>We are trying to set up BT2004 Release version on a two
>machine configuration. Windows 2003 Standard for BizTalk
>and Win2K for SQL2000. When I do the configuration, I am
>getting the following error:
>
>Failed to deploy BizTalk system aseembly "{installation
>directory}\Microsoft.BizTalk.GlobalPrpertySchemas.dll"
>
>A Microsoft distributed transaction soordinator problem
>preveted connection to the configuration database.
>The transaction has already been inplicitly or explicitly
>committed or aborted.
>
>[Microsoft.BizTalk.Deployment.DeploymentException] Cannot
>open database BizTalkMgmtDb on server ...
>
>Please help. Thank You.
>
>
>.
>
| |
| John Plummer [MSFT] 2004-03-25, 5:51 pm |
| Assume you've set network DTC on both boxes and rebooted
You can try turning off RPC Security for DTC
hklm\software\microsoft\msdtc\TurnOffRpc
Security=1 (dword) - you also need
to reboot!
Also checkout dtctester
http://support.microsoft.com/defaul...kb;en-us;293799
I know your config works fine for Windows 2003 (thats my envmt)..not sure
about Windows 2000 box running SQL...maybe some of the PSS folk can also
input...i'll double check as well and get back to you
rgds
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"AJMR" <anonymous@discussions.microsoft.com> wrote in message
news:13d8901c412b9$0ebc55d0$a101280a@phx
.gbl...
John,
Thanks for your quick reponse. I tried that it but it
still does not work. Network Admin, Transactions and
client checkboxes are on under Network DTC access.
Also I am using domain groups and accounts with domain
biztalk admin accounted added as the local admin on the
BizTalk machine. Please advise.
Thanks in advance for your help.
AJMR
>-----Original Message-----
>Goto Component Services / My Computer / Properties /
MSDTC Tab / Security
>Configuration and Enable Network DTC Access
>
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>Use of included script samples are subject to the terms
specified at
>http://www.microsoft.com/info/cpyright.htm
>
>
>"AJMR" <anonymous@discussions.microsoft.com> wrote in
message
> news:1371301c412ab$eedf84b0$a301280a@phx
.gbl...
>Hi Everyone,
>
>We are trying to set up BT2004 Release version on a two
>machine configuration. Windows 2003 Standard for BizTalk
>and Win2K for SQL2000. When I do the configuration, I am
>getting the following error:
>
>Failed to deploy BizTalk system aseembly "{installation
>directory}\Microsoft.BizTalk.GlobalPrpertySchemas.dll"
>
>A Microsoft distributed transaction soordinator problem
>preveted connection to the configuration database.
>The transaction has already been inplicitly or explicitly
>committed or aborted.
>
>[Microsoft.BizTalk.Deployment.DeploymentException] Cannot
>open database BizTalkMgmtDb on server ...
>
>Please help. Thank You.
>
>
>.
>
| |
|
| John,
No. I have enabled only BizTalk machine for network DTC
access. I do not find that option under component services
on my Win2K SQL 2000 machine. Where can I find it in
Win2K?
Which machine do I need to turn off RPC security? Thanks
for your help.
AJMR
>-----Original Message-----
>Assume you've set network DTC on both boxes and rebooted
>
>You can try turning off RPC Security for DTC
> hklm\software\microsoft\msdtc\TurnOffRpc
Security=1
(dword) - you also need
>to reboot!
>Also checkout dtctester
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;293799
>
>I know your config works fine for Windows 2003 (thats my
envmt)..not sure
>about Windows 2000 box running SQL...maybe some of the
PSS folk can also
>input...i'll double check as well and get back to you
>
>rgds
>
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>Use of included script samples are subject to the terms
specified at
>http://www.microsoft.com/info/cpyright.htm
>
>
>"AJMR" <anonymous@discussions.microsoft.com> wrote in
message
> news:13d8901c412b9$0ebc55d0$a101280a@phx
.gbl...
>John,
>
>Thanks for your quick reponse. I tried that it but it
>still does not work. Network Admin, Transactions and
>client checkboxes are on under Network DTC access.
>
>Also I am using domain groups and accounts with domain
>biztalk admin accounted added as the local admin on the
>BizTalk machine. Please advise.
>
>Thanks in advance for your help.
>
>AJMR
>
>MSDTC Tab / Security
>confers no rights.
>specified at
>message
>
>
>.
>
| |
|
| John,
DTCTester failed from BizTalk machine to SQLServer. Please
advise. Thank you.
AJMR
>-----Original Message-----
>John,
>
>No. I have enabled only BizTalk machine for network DTC
>access. I do not find that option under component
services
>on my Win2K SQL 2000 machine. Where can I find it in
>Win2K?
>
>Which machine do I need to turn off RPC security? Thanks
>for your help.
>
>AJMR
>(dword) - you also need
>us;293799
>envmt)..not sure
>PSS folk can also
>confers no rights.
>specified at
>message
explicitly[color=darkred]
Cannot[color=darkred]
>.
>
| |
|
| DTCTester is working fine from another Win2K machine to
the SQL win2K machine. So it seems the issue is with
BizTalk machine. Please advise. Thank You.
AJMR
>-----Original Message-----
>John,
>
>No. I have enabled only BizTalk machine for network DTC
>access. I do not find that option under component
services
>on my Win2K SQL 2000 machine. Where can I find it in
>Win2K?
>
>Which machine do I need to turn off RPC security? Thanks
>for your help.
>
>AJMR
>(dword) - you also need
>us;293799
>envmt)..not sure
>PSS folk can also
>confers no rights.
>specified at
>message
explicitly[color=darkred]
Cannot[color=darkred]
>.
>
| |
|
| John, we are installing BizTalk 2004 in a 2 server configuration w/ both servers being Win2K. Have gone through the docs and installed all the pre-reqs. When we install BizTalk, we get the same error mentioned here. On clicking retry, it just hangs up. Th
e config log file shows that it dies on "Create Group". We created all the groups on the SQL box in advance and added our local user into all the groups including the administrator local group on the SQL box. Also made sure the user was an admin on the SQ
L server itself.
Any ideas?
Thanks.
Harsh.
| |
|
| DTCtester is also working fine from another computer with
windows 2003 server connecting to the SQL win2K machine.
It definitely has something to do with the DTC on BizTalk
machine. DTC versions are exactly same in both Window 2003
servers connecting to the SQL. Please advise. Thank You.
AJMR
>-----Original Message-----
>John,
>
>No. I have enabled only BizTalk machine for network DTC
>access. I do not find that option under component
services
>on my Win2K SQL 2000 machine. Where can I find it in
>Win2K?
>
>Which machine do I need to turn off RPC security? Thanks
>for your help.
>
>AJMR
>(dword) - you also need
>us;293799
>envmt)..not sure
>PSS folk can also
>confers no rights.
>specified at
>message
explicitly[color=darkred]
Cannot[color=darkred]
>.
>
| |
| Gong Cheng [MSFT] 2004-10-28, 5:48 pm |
| You need to enable MSDTC and define secondary ports for MSDTC. You also
need to make sure MSDTC ports are allowed if firewalls are involved. Please
read the RTM doc for details
--------------------
Thread-Topic: Error - A DTC problem prevented connection to the
configuration database
thread-index: AcQTfHOtH17kouBmQBiZAHmSDSGYyg==
X-Tomcat-NG: microsoft.public.biztalk.setup
From: "=?Utf-8?B?SEE=?=" <anonymous@discussions.microsoft.com>
References: <1371301c412ab$eedf84b0$a301280a@phx.gbl>
<40634e20@news.microsoft.com> <13d8901c412b9$0ebc55d0$a101280a@phx.gbl>
<40636037$1@news.microsoft.com>
Subject: Re: Error - A DTC problem prevented connection to the
configuration database
Date: Fri, 26 Mar 2004 13:51:11 -0800
Lines: 6
Message-ID: <946E62B4-4542-4C1C-988A-4183DA952520@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.biztalk.setup
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.biztalk.setup:3351
NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
X-Tomcat-NG: microsoft.public.biztalk.setup
John, we are installing BizTalk 2004 in a 2 server configuration w/ both
servers being Win2K. Have gone through the docs and installed all the
pre-reqs. When we install BizTalk, we get the same error mentioned here. On
clicking retry, it just hangs up. The config log file shows that it dies on
"Create Group". We created all the groups on the SQL box in advance and
added our local user into all the groups including the administrator local
group on the SQL box. Also made sure the user was an admin on the SQL
server itself.
Any ideas?
Thanks.
Harsh.
Thanks,
Gong
|
|
|
|