Hi:
We have 2 sql server(both sql2000) and using update/insert
triggers to replicate between the 2 servers. the
replication has been working and now We got this error
when doing an update:
ole/db provider returned message, new transaction cannot
enlist in the specified transaction coordinator. the
operation could not be performed because the oledb
provider 'sqloledb' was unable to begin a distributed
transaction.
So I restarted msdtc service on both sql servers, now when
running an update, I got msdtc on server
destinationservernm is unavailable, but both dtc services
are started. Any thoughts? thanks.Which OS version?
--
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2003 All rights reserved.
"dean" <dean@.hotmail.com> wrote in message
news:016b01c377c6$693f1e40$a401280a@.phx.gbl...
> Hi:
> We have 2 sql server(both sql2000) and using update/insert
> triggers to replicate between the 2 servers. the
> replication has been working and now We got this error
> when doing an update:
> ole/db provider returned message, new transaction cannot
> enlist in the specified transaction coordinator. the
> operation could not be performed because the oledb
> provider 'sqloledb' was unable to begin a distributed
> transaction.
> So I restarted msdtc service on both sql servers, now when
> running an update, I got msdtc on server
> destinationservernm is unavailable, but both dtc services
> are started. Any thoughts? thanks.
Showing posts with label sql2000. Show all posts
Showing posts with label sql2000. Show all posts
Wednesday, March 7, 2012
Monday, February 20, 2012
MSDTC and SQL2000 clustered
Hi,
I'm in doubt about an installation of SQL Server 2000 (single istance hot standby) on a Win2000 Advanced Server 2 nodes cluster (2 processors per node).
I suppose MSDTC was not activated during SQL2000 setup.
Is it absolutely necessary?
Can I have problems?
In what case is it necessary?
Many thanks?Originally posted by nisant
Hi,
I'm in doubt about an installation of SQL Server 2000 (single istance hot standby) on a Win2000 Advanced Server 2 nodes cluster (2 processors per node).
I suppose MSDTC was not activated during SQL2000 setup.
Is it absolutely necessary?
Can I have problems?
In what case is it necessary?
Many thanks?
I had a problem in an active\active failover installation. MSDTC was not configured and was causing problems with the fail over function. Once I configured it as a shared resource, everything seemed fine. Hope this helps...|||True, make sure MSDTC has been started and working whenever any distributed transactions are in process.
For information refer to DB journal (http://www.databasejournal.com/features/mssql/article.php/1690901) article.
I'm in doubt about an installation of SQL Server 2000 (single istance hot standby) on a Win2000 Advanced Server 2 nodes cluster (2 processors per node).
I suppose MSDTC was not activated during SQL2000 setup.
Is it absolutely necessary?
Can I have problems?
In what case is it necessary?
Many thanks?Originally posted by nisant
Hi,
I'm in doubt about an installation of SQL Server 2000 (single istance hot standby) on a Win2000 Advanced Server 2 nodes cluster (2 processors per node).
I suppose MSDTC was not activated during SQL2000 setup.
Is it absolutely necessary?
Can I have problems?
In what case is it necessary?
Many thanks?
I had a problem in an active\active failover installation. MSDTC was not configured and was causing problems with the fail over function. Once I configured it as a shared resource, everything seemed fine. Hope this helps...|||True, make sure MSDTC has been started and working whenever any distributed transactions are in process.
For information refer to DB journal (http://www.databasejournal.com/features/mssql/article.php/1690901) article.
MSDTC / sql2000 active/active
We need to create an active/active sql 2000 cluster on 2003 enterprise
server. Do I need multiple MSDTC or just one?
Windows 2000/2003 server clustering only allows for instance within a
cluster.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"burt_king" <burt_king@.yahoo.com> wrote in message
news:C3B393B5-2BBA-46C5-8F4B-7942EBCD8E84@.microsoft.com...
> We need to create an active/active sql 2000 cluster on 2003 enterprise
> server. Do I need multiple MSDTC or just one?
|||Are you saying we cannot have an active/active cluster?
We're planning on having instance 1 on node 1, instance 2 on node 2.
burt_king@.yahoo.com
"Rodney R. Fournier [MVP]" wrote:
> Windows 2000/2003 server clustering only allows for instance within a
> cluster.
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://www.msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "burt_king" <burt_king@.yahoo.com> wrote in message
> news:C3B393B5-2BBA-46C5-8F4B-7942EBCD8E84@.microsoft.com...
>
>
|||No, I am saying you can only have 1 copy of MSDTC within a cluster (Longhorn
will change this...).
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"burt_king" <burt_king@.yahoo.com> wrote in message
news:F232F32F-0DF9-477B-9BBA-113FC2F4FF46@.microsoft.com...[vbcol=seagreen]
> Are you saying we cannot have an active/active cluster?
> We're planning on having instance 1 on node 1, instance 2 on node 2.
> --
> burt_king@.yahoo.com
>
> "Rodney R. Fournier [MVP]" wrote:
|||> Are you saying we cannot have an active/active cluster?
You can have multiple SQL instances, but only one MSDTC.
Linchi
"burt_king" wrote:
[vbcol=seagreen]
> Are you saying we cannot have an active/active cluster?
> We're planning on having instance 1 on node 1, instance 2 on node 2.
> --
> burt_king@.yahoo.com
>
> "Rodney R. Fournier [MVP]" wrote:
|||Great. I assume it doesn't matter which node owns the MSDTC resource... is
that correct?
"Linchi Shea" wrote:
[vbcol=seagreen]
> You can have multiple SQL instances, but only one MSDTC.
> Linchi
> "burt_king" wrote:
|||In theory yes, but we have an application that requires MSDTC to start
before its resources start. You will need to with your applications.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"burt_king" <burt_king@.yahoo.com> wrote in message
news:DEED957B-5413-4878-A163-E1BE2B20B442@.microsoft.com...[vbcol=seagreen]
> Great. I assume it doesn't matter which node owns the MSDTC resource...
> is
> that correct?
> "Linchi Shea" wrote:
|||Does SQL Server automagically configure itself to wait for MSDTC when doing
the clustered installs?
"Rodney R. Fournier [MVP]" wrote:
> In theory yes, but we have an application that requires MSDTC to start
> before its resources start. You will need to with your applications.
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "burt_king" <burt_king@.yahoo.com> wrote in message
> news:DEED957B-5413-4878-A163-E1BE2B20B442@.microsoft.com...
>
>
|||Er, no - since mine are in different groups.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"burt_king" <burt_king@.yahoo.com> wrote in message
news:95C0486B-FA13-4085-ADF4-81DF2301E393@.microsoft.com...[vbcol=seagreen]
> Does SQL Server automagically configure itself to wait for MSDTC when
> doing
> the clustered installs?
> --
> "Rodney R. Fournier [MVP]" wrote:
server. Do I need multiple MSDTC or just one?
Windows 2000/2003 server clustering only allows for instance within a
cluster.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"burt_king" <burt_king@.yahoo.com> wrote in message
news:C3B393B5-2BBA-46C5-8F4B-7942EBCD8E84@.microsoft.com...
> We need to create an active/active sql 2000 cluster on 2003 enterprise
> server. Do I need multiple MSDTC or just one?
|||Are you saying we cannot have an active/active cluster?
We're planning on having instance 1 on node 1, instance 2 on node 2.
burt_king@.yahoo.com
"Rodney R. Fournier [MVP]" wrote:
> Windows 2000/2003 server clustering only allows for instance within a
> cluster.
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://www.msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "burt_king" <burt_king@.yahoo.com> wrote in message
> news:C3B393B5-2BBA-46C5-8F4B-7942EBCD8E84@.microsoft.com...
>
>
|||No, I am saying you can only have 1 copy of MSDTC within a cluster (Longhorn
will change this...).
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"burt_king" <burt_king@.yahoo.com> wrote in message
news:F232F32F-0DF9-477B-9BBA-113FC2F4FF46@.microsoft.com...[vbcol=seagreen]
> Are you saying we cannot have an active/active cluster?
> We're planning on having instance 1 on node 1, instance 2 on node 2.
> --
> burt_king@.yahoo.com
>
> "Rodney R. Fournier [MVP]" wrote:
|||> Are you saying we cannot have an active/active cluster?
You can have multiple SQL instances, but only one MSDTC.
Linchi
"burt_king" wrote:
[vbcol=seagreen]
> Are you saying we cannot have an active/active cluster?
> We're planning on having instance 1 on node 1, instance 2 on node 2.
> --
> burt_king@.yahoo.com
>
> "Rodney R. Fournier [MVP]" wrote:
|||Great. I assume it doesn't matter which node owns the MSDTC resource... is
that correct?
"Linchi Shea" wrote:
[vbcol=seagreen]
> You can have multiple SQL instances, but only one MSDTC.
> Linchi
> "burt_king" wrote:
|||In theory yes, but we have an application that requires MSDTC to start
before its resources start. You will need to with your applications.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"burt_king" <burt_king@.yahoo.com> wrote in message
news:DEED957B-5413-4878-A163-E1BE2B20B442@.microsoft.com...[vbcol=seagreen]
> Great. I assume it doesn't matter which node owns the MSDTC resource...
> is
> that correct?
> "Linchi Shea" wrote:
|||Does SQL Server automagically configure itself to wait for MSDTC when doing
the clustered installs?
"Rodney R. Fournier [MVP]" wrote:
> In theory yes, but we have an application that requires MSDTC to start
> before its resources start. You will need to with your applications.
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "burt_king" <burt_king@.yahoo.com> wrote in message
> news:DEED957B-5413-4878-A163-E1BE2B20B442@.microsoft.com...
>
>
|||Er, no - since mine are in different groups.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"burt_king" <burt_king@.yahoo.com> wrote in message
news:95C0486B-FA13-4085-ADF4-81DF2301E393@.microsoft.com...[vbcol=seagreen]
> Does SQL Server automagically configure itself to wait for MSDTC when
> doing
> the clustered installs?
> --
> "Rodney R. Fournier [MVP]" wrote:
Subscribe to:
Posts (Atom)