MSDTC and Win2K3: February 2012

Saturday, February 25, 2012

MsDTc on each node feasibly?

Is there a possibility to create on each node a MSDTC resource (even local on
each server)?
When you talk about a MSDTC resource, I assume you are talking about it as a
cluster resource. There is only one MSDTC resource in a cluster, not one for
each node.
What may be the reason you want it on each node?
Linchi
"Walter" <Walter@.discussions.microsoft.com> wrote in message
news:F712ECF3-D326-4CCC-8BCD-AA2425A6B503@.microsoft.com...
> Is there a possibility to create on each node a MSDTC resource (even local
> on
> each server)?
|||Thanks for the confirmation. The reason is I like to create a DB env.
active/active for our application that needs MsDTc. The first node DB for
the application and the second node for reporting and is a replicata of the
first DB.
Do you have maybe a solution for this?
Many thanks in advance,
Walter
"Linchi Shea" schreef:

> When you talk about a MSDTC resource, I assume you are talking about it as a
> cluster resource. There is only one MSDTC resource in a cluster, not one for
> each node.
> What may be the reason you want it on each node?
> Linchi
> "Walter" <Walter@.discussions.microsoft.com> wrote in message
> news:F712ECF3-D326-4CCC-8BCD-AA2425A6B503@.microsoft.com...
>
>
|||You can have multiple SQL instances on a cluster. You still need only one
instance of MSDTC for the entire cluster. There are several techniques that
will allow you to create the shadow database for reporting. Replication and
Log shipping are the most popular. Each has its own advantages and
disatvantages, so it is important to learn the capabilities of each.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Walter" <Walter@.discussions.microsoft.com> wrote in message
news:7CB2BC93-2B37-471B-BD4B-049A1F71658D@.microsoft.com...[vbcol=seagreen]
> Thanks for the confirmation. The reason is I like to create a DB env.
> active/active for our application that needs MsDTc. The first node DB for
> the application and the second node for reporting and is a replicata of
> the
> first DB.
> Do you have maybe a solution for this?
> Many thanks in advance,
> Walter
> "Linchi Shea" schreef:

MSDTC on a SQL2005 failover cluster

Does MSDTC always need to be installed on a SQL failover cluster? the dev
team writing the app which will reside on the cluster say MSDTC isnt needed
as they dont use 2 phase commit or replication but I cant find anything
definitive which says the SQL failover cluster will be fine without MSDTC.
I'm coming to the conclusion it isnt needed for this install but I have to
be sure because installing MSDTC after SQL isnt recommended. I'm also
pondering on installing it anyway to be on the safe side so any advice
appreciatted
MSDTC is not required in a SQL cluster if you don't use it. But the problem
is that your app may start to use it a few months down the road without
informing you of the change in advance.
I'd always install it anyway as part of the standard. If they use it, it's
there. if they don't use it, no much is wasted.
Linchi
"Enghps1" wrote:

> Does MSDTC always need to be installed on a SQL failover cluster? the dev
> team writing the app which will reside on the cluster say MSDTC isnt needed
> as they dont use 2 phase commit or replication but I cant find anything
> definitive which says the SQL failover cluster will be fine without MSDTC.
> I'm coming to the conclusion it isnt needed for this install but I have to
> be sure because installing MSDTC after SQL isnt recommended. I'm also
> pondering on installing it anyway to be on the safe side so any advice
> appreciatted
>
>

MSDTC not available

It is possible to copy the data from table to Excel file with
OpenRowset command
When I tried to copy the result set of stored procedure to Excel file
by using this query
Insert into
OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=F:\v1.xls;HDR=YES',
'SELECT * FROM [Sheet1$]')
Exec mysp 'test','testing'
I got the error
Server: Msg 8501, Level 16, State 3, Line 3
MSDTC on server 'SYS7' is unavailable.
What am I missing?
MadhivananFirst, I would check that the Distributed Transaction Controller is on. The
service can be disabled and is, by default, in certain scenarios. I will see
if I can find anything else to help in this situation.
In response, give an idea of the setup you are running under, as that could
affect the answer. Any additional information on what you are doing would
also be useful.
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
***************************
Think Outside the Box!
***************************
"Madhivanan" wrote:

> It is possible to copy the data from table to Excel file with
> OpenRowset command
> When I tried to copy the result set of stored procedure to Excel file
> by using this query
> Insert into
> OPENROWSET('Microsoft.Jet.OLEDB.4.0',
> 'Excel 8.0;Database=F:\v1.xls;HDR=YES',
> 'SELECT * FROM [Sheet1$]')
> Exec mysp 'test','testing'
> I got the error
> Server: Msg 8501, Level 16, State 3, Line 3
> MSDTC on server 'SYS7' is unavailable.
> What am I missing?
>
> Madhivanan
>|||I just want to copy the result set of sp to Excel
I tried it with table and it is working perfectly
I am using SQL Server2000 with Service Pack 4 and Excel version is 2000
Madhivanan|||Still I didnot solve this problem
Any other ideas?
Madhivanan

MSDTC name resolution - two servers same bios name

Is there any way to set up name resolution for DTC when there are two servers with the same name? I have three servers - two production systems named "SQL" and an archive system "DMART". I want to run DTC procedures to archive data from both SQL's to the DMART. Is there any way to set up the DMART so it can properly resolve the names from each of the SQL's? They are on separate networks, but unfortunately have the same NetBIOS name.When two computers that are not running in the same domain use MSDTC for communication and for distributed transactions, the mutual authentication may fail.

And I don't think its possible to set name resolution if the BIOS is similar.|||Can the #DOM: option in the lmhosts file be used to specify different networks for hosts with the same BIOS name? Will DTC recognize the #DOM: option during name resolution?|||Added after an entry to associate that entry with the domain specified by domain. This keyword affects how the Browser and Logon services behave in routed TCP/IP environments.

Still I'm bit unsure about the approach, may try and take help of network admin.

MSDTC Msg 8501

OS: Windows 2000

SQL Version: SQL 2000 - 8.00.818 (SP3) Standard

MSDTC Version: 03.00.00.3421

I am getting error message 8501 when I try to run any queries against this linked server from several environments (from Win2003 Server, XP). I have read that the MSDTC service needs to run under the NT AUTHORITY\NetworkService login. I cannot get it to be set to this login. How do I make this change. If I uninstall the service and reinstall, I still get it to default to local system account.

What I am needing is:

How do I set the NT Authority\NetworkService account for the MSDTC service?

How do I set the MSDTC service to run with remote connections comming in?

Please let me know what other information you will need.

Thank you for any help you may give.

One of the KBA refers:

Make sure that the Log On As account for the MSDTC service is the Network Service account. To do this, follow these steps:

Click Start, and then click Run.

In the Run dialog box, type Services.msc, and then click OK.

In the Services window, locate the Distributed Transaction Coordinator service under Name in the right pane.

Under the Log On As column, see whether the Log On As account is Network Service or Local System.

If the Log On As account is Network Service, go to step 2. If the Log On As account is Local System account, continue with these steps.

Click Start, and then click Run.

In the Run dialog box, type cmd, and then click OK.

Enable MSDTC to allow the network transaction. To do this, follow these steps:

Click Start, and then click Run.

In the Run dialog box, type dcomcnfg.exe, and then click OK.

In the Component Services window, expand Component Services, expand Computers, and then expand My Computer.

Right-click My Computer, and then click Properties.

In the My Computer Properties dialog box, click Security Configuration on the MSDTC tab.

In the Security Configuration dialog box, click to select the Network DTC Access check box.

To allow the distributed transaction to run on this computer from a remote computer, click to select the Allow Inbound check box.

To allow the distributed transaction to run on a remote computer from this computer, click to select the Allow Outbound check box.

Under the Transaction Manager Communication group, click to select the No Authentication Required option.

In the Security Configuration dialog box, click OK.

In the My Computer Properties dialog box, click OK.

|||

I have found these instructions, but they are for Windows 2003 Server and I am running Windows 2000 Server. I do appreciate your reply and I followed the directions as outlined, but the My Computer Properties within the Component Services does not show these options.

Within the Distributed Transaction Coordinator service properties I cannot get it to log on as the Network Service. I have un-installed MSDTC, deleted the registry key, re-installed MSDTC and it defaults to the Local System account, not the Network Service account. Now distributed transactions are receiving the error Msg 8501. I have deleted the linked server and re-created the linked server and I am still getting this same error.

|||

Strange, I've followed the same on a windows 2000 SP4 advanced server box without any issues.

Please specify the WIndows OS service pack level too.

GeneralSQL wrote:

I have found these instructions, but they are for Windows 2003 Server and I am running Windows 2000 Server. I do appreciate your reply and I followed the directions as outlined, but the My Computer Properties within the Component Services does not show these options.
Within the Distributed Transaction Coordinator service properties I cannot get it to log on as the Network Service. I have un-installed MSDTC, deleted the registry key, re-installed MSDTC and it defaults to the Local System account, not the Network Service account. Now distributed transactions are receiving the error Msg 8501. I have deleted the linked server and re-created the linked server and I am still getting this same error.

|||

Microsoft Windows 2000

5.00.2195

Service Pack 4

It is not advanced server, but the standard edition.

MSDTC message

I have SQL 2000 running on Windows 2000 server and I several entires in the
application event view as follow:
"string message session idle timeout over tearing down the session"
What does this mean?
Thank You,
PIt means it took too long for all of the participants in the transaction to
commit or rollback their piece of the transaction or to communicate such
activity. MSDTC is rolling back the changes.
This usually will come up whenever there is a service restart on one of the
participants also.
Sincerely,
Anthony Thomas
"p" <p@.discussions.microsoft.com> wrote in message
news:AEB53470-938A-4F7C-AF69-878D1FC864D3@.microsoft.com...
I have SQL 2000 running on Windows 2000 server and I several entires in the
application event view as follow:
"string message session idle timeout over tearing down the session"
What does this mean?
Thank You,
P

MSDTC message

I have SQL 2000 running on Windows 2000 server and I several entires in the
application event view as follow:
"string message session idle timeout over tearing down the session"
What does this mean?
Thank You,
P
It means it took too long for all of the participants in the transaction to
commit or rollback their piece of the transaction or to communicate such
activity. MSDTC is rolling back the changes.
This usually will come up whenever there is a service restart on one of the
participants also.
Sincerely,
Anthony Thomas

"p" <p@.discussions.microsoft.com> wrote in message
news:AEB53470-938A-4F7C-AF69-878D1FC864D3@.microsoft.com...
I have SQL 2000 running on Windows 2000 server and I several entires in the
application event view as follow:
"string message session idle timeout over tearing down the session"
What does this mean?
Thank You,
P

MSDTC message

MSDTC is unavailable.

The following code:

DECLARE @.tsql varchar(1000)
CREATE TABLE #Test (...)
SET @.tsql = 'SELECT * FROM OPENQUERY(MyDataSource, ...)'
INSERT INTO #Test EXEC(@.tsql)

generates the following error message at the insert statement:

Server: Msg 8501, Level 16, State 3, Line 4
MSDTC on server 'MyComputer' is unavailable.

Why?

Thanks,
Tony Perovic
Compumation, Inc.Starting the DTC service caused the problem to go away but why does it need
it?

"tperovic" <tonyperovic@.yahoo.com> wrote in message
news:_bfLc.5403$iK.4645@.newsread2.news.atl.earthli nk.net...
> The following code:
> DECLARE @.tsql varchar(1000)
> CREATE TABLE #Test (...)
> SET @.tsql = 'SELECT * FROM OPENQUERY(MyDataSource, ...)'
> INSERT INTO #Test EXEC(@.tsql)
> generates the following error message at the insert statement:
> Server: Msg 8501, Level 16, State 3, Line 4
> MSDTC on server 'MyComputer' is unavailable.
> Why?
> Thanks,
> Tony Perovic
> Compumation, Inc.|||tperovic (tonyperovic@.yahoo.com) writes:
> Starting the DTC service caused the problem to go away but why does it
> need it?
>> DECLARE @.tsql varchar(1000)
>> CREATE TABLE #Test (...)
>> SET @.tsql = 'SELECT * FROM OPENQUERY(MyDataSource, ...)'
>> INSERT INTO #Test EXEC(@.tsql)

Because you call the other server in the context of a transaction,
defined by the INSERT statement.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

msdtc is down

The resource msdtc is down. Every time, it works pretty well , after we restart the servers(node1 and node2). But, about half a hour later, the problem is there. We reintalled msdtc. It didn't work out too. msdtc and sql server is on a cluster. Can anyone help me out?

What has this got to do with SSIS, the title of this forum?

Have you looked at any MS DTC troubleshooting resources?

Have you looked in the event log?

msdtc is causing my cluster to be unavailiable via it's virtual na

I have windows 2003 sp1 running in a 2-node cluster. The cluster is running
sql sp4. I tried failing over my cluster after a windows update and i'm not
sure if that's what threw my server's off or something else. But here's the
situation. I currently have the cluster group running on node 2, the msdtc
running on node 1 and the sql group running on node 2. When i move the msdtc
group to node 2 (ie.. the server which should be running all services)i cant
ping the sql virtual server by name or ip. I am however able to contact the
individual servers via their names sql1 and sql2. So basically i lose my
connection to the virtual sql server throughout my network when the msdtc is
running on the same server. Is there an update? upgrade? to the msdtc or
anything else i can do to fix this issue?
Ohh yes and there's no errors in the event log.
What are the Resource Group names, Resource Network Names, and Resource IP
addresses? What other resources a apart of each group?
Sounds like a DNS registration issue. Does the SQL Server group go offline
or fail over when the MSDTC group is moved to node 2?
Sincerely,
Anthony Thomas

"Sunny" <Sunny@.discussions.microsoft.com> wrote in message
news:12879549-04B5-454B-A44C-C075061EAEC1@.microsoft.com...
> I have windows 2003 sp1 running in a 2-node cluster. The cluster is
running
> sql sp4. I tried failing over my cluster after a windows update and i'm
not
> sure if that's what threw my server's off or something else. But here's
the
> situation. I currently have the cluster group running on node 2, the
msdtc
> running on node 1 and the sql group running on node 2. When i move the
msdtc
> group to node 2 (ie.. the server which should be running all services)i
cant
> ping the sql virtual server by name or ip. I am however able to contact
the
> individual servers via their names sql1 and sql2. So basically i lose my
> connection to the virtual sql server throughout my network when the msdtc
is
> running on the same server. Is there an update? upgrade? to the msdtc or
> anything else i can do to fix this issue?
> Ohh yes and there's no errors in the event log.

MSDTC IN WIN 2003 CLUSTER

Hi Guys,
rirht now my databases running on two seperate sql servers
server1 and server2 and ecah having MSDTC .
Now i am planning to shift these two servers into a
cluster.
1)shall i go for active/passive or active/active.
2)if active/active then it will be named virtual instance
will it require any modification in the application other
than changing the connection string.
3)in any case how MSDTC will get affected in the new
cluster.
4) how sql server will identify the MSDTC AS it is having
different network name, ip address tec
pls advice.
Answers inline...
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"Bijupg" <anonymous@.discussions.microsoft.com> wrote in message
news:173e01c51e37$f62aecd0$a501280a@.phx.gbl...
> Hi Guys,
> rirht now my databases running on two seperate sql servers
> server1 and server2 and ecah having MSDTC .
> Now i am planning to shift these two servers into a
> cluster.
> 1)shall i go for active/passive or active/active.
Do your databases require the complete power of the current machines? Will
the clustered machines be the same power or more powerful then the current
machines? What about current RAM and clustered RAM?

> 2)if active/active then it will be named virtual instance
> will it require any modification in the application other
> than changing the connection string.
You can only have one default instance in a SQL cluster. If you need two
instances, at least one will be named.

> 3)in any case how MSDTC will get affected in the new
> cluster.
MSDTC will be shared. Follow 817064 and then 301600.

> 4) how sql server will identify the MSDTC AS it is having
> different network name, ip address tec
> pls advice.
>
That is all part of the SQL magic and clustering. Ok, so I have no idea, but
I know it works well

|||As for your MSDTC here is the basic best pratice on this
When clustering MS DTC it is preferred to have it in its own group with its
own resources, your second choice should be to put it in the cluster group,
use the quorum disk and create MS DTC its own Network Name and IP Address
resources for your MSDTC resource to use and set that resources properties
not to affect the group.
Here are some KB articles on correctly setting this up:
301600 How to configure Microsoft Distributed Transaction Coordinator on a
http://support.microsoft.com/?id=301600
817064 How to enable network DTC access in Windows Server 2003
http://support.microsoft.com/?id=817064
Also this article which may be of interest:
817065 How To Enable Network COM Access in Windows Server 2003
http://support.microsoft.com/?id=817065
Dave Whitney
SQL Support

MSDTC in sql install.

Hi,
i need to install sql 2000 cluster on win 2003.
i have all the maluals but something is not clear for me .
do i need to install MSDTC before !!! the sql set up via comclust.exe
on each node (like i wrote the OS is win2k3)
thank`s,
Ronald.
In previous versions of Windows, the COMCLUST.EXE utility had to be run on
each node in order to cluster the MSDTC. Under Windows 2003, it is now
possible to configure MSDTC as a resource type, assign it to a resource
group, and have it automatically configured on all cluster nodes
COMCLUST.EXE falls away.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"w2system5" <none@.none.com> wrote in message
news:cph3em$nvb$1@.news2.netvision.net.il...
> Hi,
> i need to install sql 2000 cluster on win 2003.
> i have all the maluals but something is not clear for me .
> do i need to install MSDTC before !!! the sql set up via comclust.exe
> on each node (like i wrote the OS is win2k3)
> thank`s,
> Ronald.
>
|||First of all do you even need MSDTC? Do you have any applications written to
use it?
If so, do 817064 BEFORE you install clustering.
Then 301600 BEFORE you install SQL.
Also, Microsoft recommends to run MSDTC and SQL on the same node.
For complete detail see the revised
http://msmvps.com/clustering/archive.../25/16672.aspx blog post.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"w2system5" <none@.none.com> wrote in message
news:cph3em$nvb$1@.news2.netvision.net.il...
> Hi,
> i need to install sql 2000 cluster on win 2003.
> i have all the maluals but something is not clear for me .
> do i need to install MSDTC before !!! the sql set up via comclust.exe
> on each node (like i wrote the OS is win2k3)
> thank`s,
> Ronald.
>
|||> Also, Microsoft recommends to run MSDTC and SQL on the same node.
Really? What happens if you have two SQL instances running on two different
nodes?
Linchi
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:OJUNzLG4EHA.1564@.TK2MSFTNGP09.phx.gbl...
> First of all do you even need MSDTC? Do you have any applications written
to[vbcol=seagreen]
> use it?
> If so, do 817064 BEFORE you install clustering.
> Then 301600 BEFORE you install SQL.
> Also, Microsoft recommends to run MSDTC and SQL on the same node.
> For complete detail see the revised
> http://msmvps.com/clustering/archive.../25/16672.aspx blog post.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://www.msmvps.com/clustering - Blog
> "w2system5" <none@.none.com> wrote in message
> news:cph3em$nvb$1@.news2.netvision.net.il...
comclust.exe
>
|||Good point. I did think to ask support that question when I had them on the
line. I was only running one instance. Hmm. I will tell you this, I tested
our config with MSDTC running on one node and SQL on the other, everything
worked great

Rod
"Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
news:OGa111l4EHA.2180@.TK2MSFTNGP10.phx.gbl...
> Really? What happens if you have two SQL instances running on two
> different
> nodes?
> Linchi
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:OJUNzLG4EHA.1564@.TK2MSFTNGP09.phx.gbl...
> to
> comclust.exe
>
|||My understanding is that when you cluster MSDTC it installs DTC re-directs
on all nodes to the clustered MSDTC so it doesn't matter which node it runs
on.
Otherwise MSDTC would HAVE to be in the same group as the SQL Server
instance, which it doesn't.
Christian Bolton
Microsoft
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:eDYSemm4EHA.2192@.TK2MSFTNGP14.phx.gbl...
> Good point. I did think to ask support that question when I had them on
> the line. I was only running one instance. Hmm. I will tell you this, I
> tested our config with MSDTC running on one node and SQL on the other,
> everything worked great

> Rod
> "Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
> news:OGa111l4EHA.2180@.TK2MSFTNGP10.phx.gbl...
>

MSDTC in Default Cluster Group

Hi,
Can I put the MSDTC resource in Defaul Cluster Group ? I dont have available
disk to it.
thanks,
Rubens
Yes, you can put it in this group, but this goes against best practices. You
might want to consider unchecking the "affect the group" paramter for this
resource so a failure of this resource does not kill your cluster group.
Regards,
John
"Rubens Luque Sanches Jr." <rubensluque@.yahoo.com.br> wrote in message
news:eQeH1N4HFHA.2784@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Can I put the MSDTC resource in Defaul Cluster Group ? I dont have
available
> disk to it.
> thanks,
> Rubens
>
|||If one node fail,can msdtc resource automatically move to another node?
Could you tell me more information about following line?
You might want to consider unchecking the "affect the group" paramter for
this resource so a failure of this resource does not kill your cluster
group.
"John Toner [MVP]" <jtoner@.DIE.SPAM.DIE.mvps.org> д?:%23i%23CfY$HFHA.588@.TK2MSFTNGP15.phx. gbl...
> Yes, you can put it in this group, but this goes against best practices.
> You
> might want to consider unchecking the "affect the group" paramter for this
> resource so a failure of this resource does not kill your cluster group.
> Regards,
> John
> "Rubens Luque Sanches Jr." <rubensluque@.yahoo.com.br> wrote in message
> news:eQeH1N4HFHA.2784@.TK2MSFTNGP09.phx.gbl...
> available
>
|||Yes, please read through the following KB article for more details about
setting up MSDTC resource in the cluster.
http://support.microsoft.com/kb/301600
Regards,
John
"lv ming tong" <lmt@.taeco.com.diss> wrote in message
news:uTuiBG3IFHA.1304@.TK2MSFTNGP09.phx.gbl...
> If one node fail,can msdtc resource automatically move to another node?
> Could you tell me more information about following line?
> You might want to consider unchecking the "affect the group" paramter for
> this resource so a failure of this resource does not kill your cluster
> group.
>
> "John Toner [MVP]" <jtoner@.DIE.SPAM.DIE.mvps.org>
д?:%23i%23CfY$HFHA.588@.TK2MSFTNGP15.phx. gbl...[vbcol=seagreen]
this
>
|||While SQL Server does not require MS DTC, MS DTC on a cluster is only
supported when clustered and it is recommended to cluster it.
When clustering MS DTC it is preferred to have it in its own group with its
own resources, your second choice should be to put it in the cluster group,
use the quorum disk and create MS DTC its own Network Name and IP Address
resources for your MSDTC resource to use and set that resources properties
not to affect the group.
Here are some KB articles on correctly setting this up:
301600 How to configure Microsoft Distributed Transaction Coordinator on a
http://support.microsoft.com/?id=301600
817064 How to enable network DTC access in Windows Server 2003
http://support.microsoft.com/?id=817064
Also this article which may be of interest:
817065 How To Enable Network COM Access in Windows Server 2003
http://support.microsoft.com/?id=817065
Dave Whitney
SQL Support

MSDTC in Cluster Group

Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even if
the MSDTC has its own IP Address and Network Name?
In my planned multiple instance sql cluster, I can see giving up a physical
disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC
doesn't use tons on disk space, can I put it in the same group as the defualt
instance of SQL, again as long has it has its own IP Address and Network
Name?
The original MS KB posts recommended using the Cluster Group resource;
however, we've found out that it does not work and an instance of SQL Server
can not bind to it unless it's on the same node.
You can put it in the SQL Server Group resource, but it won't work once you
go multi-instanced. At that point, MS recommends that you create a seperate
shared disk resource with its own IP and Network Name resources and cluster
MS DTC as a seperate group. Looks like the coders didn't think through the
implications of the Quorum and coded against it. The SQL Server
developement group did not realize this.
Sincerely,
Anthony Thomas

"Wayne" <Wayne@.discussions.microsoft.com> wrote in message
news:922FDA87-A645-43C7-8442-BAD97525A3F1@.microsoft.com...
Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even
if
the MSDTC has its own IP Address and Network Name?
In my planned multiple instance sql cluster, I can see giving up a physical
disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC
doesn't use tons on disk space, can I put it in the same group as the
defualt
instance of SQL, again as long has it has its own IP Address and Network
Name?

MSDTC in Cluster Group

Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even if
the MSDTC has its own IP Address and Network Name?
In my planned multiple instance sql cluster, I can see giving up a physical
disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC
doesn't use tons on disk space, can I put it in the same group as the defualt
instance of SQL, again as long has it has its own IP Address and Network
Name?The original MS KB posts recommended using the Cluster Group resource;
however, we've found out that it does not work and an instance of SQL Server
can not bind to it unless it's on the same node.
You can put it in the SQL Server Group resource, but it won't work once you
go multi-instanced. At that point, MS recommends that you create a seperate
shared disk resource with its own IP and Network Name resources and cluster
MS DTC as a seperate group. Looks like the coders didn't think through the
implications of the Quorum and coded against it. The SQL Server
developement group did not realize this.
Sincerely,
Anthony Thomas
"Wayne" <Wayne@.discussions.microsoft.com> wrote in message
news:922FDA87-A645-43C7-8442-BAD97525A3F1@.microsoft.com...
Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even
if
the MSDTC has its own IP Address and Network Name?
In my planned multiple instance sql cluster, I can see giving up a physical
disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC
doesn't use tons on disk space, can I put it in the same group as the
defualt
instance of SQL, again as long has it has its own IP Address and Network
Name?

MSDTC in Active/Active MSCS cluster

How do I install MSDTC in an active/active MSCS cluster environment?
If I run comclust.exe, I can only activate MSDTC on one of the nodes at a time.
I need DTC on both nodes.
(Opsys is W2K with SQL 2000)
//Mange :)DTC is a shared service and needs to run from a shared disk. It can't have multiple instances.|||What Do you mean with multiple instances? On the same disk?

There are 2 servers in the MSCS cluster.
On each physical server, there is a virtual SQL server that has it's own shared disk.

Is it possible to start DTC on both nodes at the same time in this
configuration?

Regards
Mange :)

MSDTC Group

I have the MSDTC group with resources in a SQL Server cluster.
The MSDTC group and resources are all online from Cluster Administrator. If
check SQL Server Support Service it show the service as stopped. The Server
services shows the MSDTC to off.
Please help me with these results.
1. Are you looking in the active or passive node? Which user are you logged
on as in enterprise manager , is it an admin account?
2. Check the APP and SYS logs for any MSDTC errors
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

MSDTC forcing distributed transaction

We're performing the following query from a stored procedure on our
SQL Server database:
Begin Transaction
insert into local SQL Server table
select *
from OPENQUERY(DB2 Linked Server, 'select * from DB2 Table')
Commit Transaction
When this runs, SQL Server escalates it to a distributed transaction
and MSDTC manages the transaction.
The problem is that this transaction is not always successfully
committed on the DB2 side. As part of trying to figure out why, we're
trying to figure out why this is even a distributed transaction, since
the only update is occuring locally. Why does this query force a
distributed transaction? Is there some way to reconfigure it so that
a distributed transaction is not forced?
Kees VanTilburg
VanTilburg Enterprises
Hello kees,
If I learned correctly that you want to know why the following sql
statements use the distributed transaction.
Begin Transaction
insert into local SQL Server table
select * from OPENQUERY(DB2 Linked Server, 'select * from DB2 Table')
Commit Transaction
As far as I know, When you execute a distributed query while in a local
transaction. If the OLE DB data source supports the ITransactionJoin
interface, the transaction is promoted to a distributed transaction, even
if the query is a read-only query. Therefore, I am afraid there is not an
easy way to reconfigure so that a distributed transaction is not used in
this situation.
I found the following article for your reference.
274348 INF: Distributed Queries Executed Within a Trigger Enlist MSDTC
http://support.microsoft.com/?id=274348
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

MSDTC forcing distributed transaction

We're performing the following query from a stored procedure on our
SQL Server database:
Begin Transaction
insert into local SQL Server table
select *
from OPENQUERY(DB2 Linked Server, 'select * from DB2 Table')
Commit Transaction
When this runs, SQL Server escalates it to a distributed transaction
and MSDTC manages the transaction.
The problem is that this transaction is not always successfully
committed on the DB2 side. As part of trying to figure out why, we're
trying to figure out why this is even a distributed transaction, since
the only update is occuring locally. Why does this query force a
distributed transaction? Is there some way to reconfigure it so that
a distributed transaction is not forced?
Kees VanTilburg
VanTilburg EnterprisesHello kees,
If I learned correctly that you want to know why the following sql
statements use the distributed transaction.
Begin Transaction
insert into local SQL Server table
select * from OPENQUERY(DB2 Linked Server, 'select * from DB2 Table')
Commit Transaction
As far as I know, When you execute a distributed query while in a local
transaction. If the OLE DB data source supports the ITransactionJoin
interface, the transaction is promoted to a distributed transaction, even
if the query is a read-only query. Therefore, I am afraid there is not an
easy way to reconfigure so that a distributed transaction is not used in
this situation.
I found the following article for your reference.
274348 INF: Distributed Queries Executed Within a Trigger Enlist MSDTC
http://support.microsoft.com/?id=274348
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

MSDTC forcing distributed transaction

We're performing the following query from a stored procedure on our
SQL Server database:
Begin Transaction
insert into local SQL Server table
select *
from OPENQUERY(DB2 Linked Server, 'select * from DB2 Table')
Commit Transaction
When this runs, SQL Server escalates it to a distributed transaction
and MSDTC manages the transaction.
The problem is that this transaction is not always successfully
committed on the DB2 side. As part of trying to figure out why, we're
trying to figure out why this is even a distributed transaction, since
the only update is occuring locally. Why does this query force a
distributed transaction? Is there some way to reconfigure it so that
a distributed transaction is not forced?
Kees VanTilburg
VanTilburg EnterprisesHello kees,
If I learned correctly that you want to know why the following sql
statements use the distributed transaction.
Begin Transaction
insert into local SQL Server table
select * from OPENQUERY(DB2 Linked Server, 'select * from DB2 Table')
Commit Transaction
As far as I know, When you execute a distributed query while in a local
transaction. If the OLE DB data source supports the ITransactionJoin
interface, the transaction is promoted to a distributed transaction, even
if the query is a read-only query. Therefore, I am afraid there is not an
easy way to reconfigure so that a distributed transaction is not used in
this situation.
I found the following article for your reference.
274348 INF: Distributed Queries Executed Within a Trigger Enlist MSDTC
http://support.microsoft.com/?id=274348
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

MSDTC fails on Windows 2003 but security has been reset so its not that.

I am running SQL Server 2000 (clustered server) with Windows 2003. For some reason MSDTC is failing on distributed transactions. I can run code that begins and commits a transaction from query analyzer, or run a stored procedure from Query Analyzer with the same code in it and both work great, but if I call the stored procedure from a DTS job, then the job fails with the following error:

DTSStep_DTSExecuteSQLTask_1, Error = -2147217900 (80040E14) Error string: The operation could not be performed because the OLE DB provider 'MSDASQL' was unable to begin a distributed transaction. Error source: ..... Error string: OLE DB error trace [OLE/DB Provider 'MSDASQL' ITransactionJoin::JoinTransaction returned 0x8004d00a]. Error source: Microsoft OLE DB Provider for SQL Serve. The step failed.

Any help would be appreciated!Ensure MSDTC is started on the machine.
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=3451 for your reference.

MSDTC fails on Windows 2000 Advanced Server SP4

I have a VB6 application that uses MTS in a COM+ package for
transaction based processing over MSDTC. This application was working
fine when run from the SQL Server machine on Windows 2000 Advanced
Server until the latest security updates were installed. Now the
application fails to connect to SQL Server when the call is made inside
a transaction context within MTS/COM+
I have verified that MSDTC is started
The DTCTester tool runs successfully
RPC port 135 is open
This application runs fine on a Windows 2000 Server machine with SP4.
What is different about Windows 2000 Advanced Server such that it no
longer works after applying security updates (SP4)?
?s your SQL server and application server are in same domain, do you have
firewall etc between SQL Server and appl. server?
We had problems after we install Windows 2003 SP1 with MSDTC, we select No
Authantication Required and the problem is gone. Maybe because of you have
applied security patches you are having the same problem.
Check out:
http://support.microsoft.com/?id=883960
Hope this helps.
"dhalb@.comcast.net" wrote:

> I have a VB6 application that uses MTS in a COM+ package for
> transaction based processing over MSDTC. This application was working
> fine when run from the SQL Server machine on Windows 2000 Advanced
> Server until the latest security updates were installed. Now the
> application fails to connect to SQL Server when the call is made inside
> a transaction context within MTS/COM+
> I have verified that MSDTC is started
> The DTCTester tool runs successfully
> RPC port 135 is open
> This application runs fine on a Windows 2000 Server machine with SP4.
> What is different about Windows 2000 Advanced Server such that it no
> longer works after applying security updates (SP4)?
>

MSDTC fails on Windows 2000 Advanced Server SP4

I have a VB6 application that uses MTS in a COM+ package for
transaction based processing over MSDTC. This application was working
fine when run from the SQL Server machine on Windows 2000 Advanced
Server until the latest security updates were installed. Now the
application fails to connect to SQL Server when the call is made inside
a transaction context within MTS/COM+
I have verified that MSDTC is started
The DTCTester tool runs successfully
RPC port 135 is open
This application runs fine on a Windows 2000 Server machine with SP4.
What is different about Windows 2000 Advanced Server such that it no
longer works after applying security updates (SP4)'Ä°s your SQL server and application server are in same domain, do you have
firewall etc between SQL Server and appl. server?
We had problems after we install Windows 2003 SP1 with MSDTC, we select No
Authantication Required and the problem is gone. Maybe because of you have
applied security patches you are having the same problem.
Check out:
http://support.microsoft.com/?id=883960
Hope this helps.
"dhalb@.comcast.net" wrote:
> I have a VB6 application that uses MTS in a COM+ package for
> transaction based processing over MSDTC. This application was working
> fine when run from the SQL Server machine on Windows 2000 Advanced
> Server until the latest security updates were installed. Now the
> application fails to connect to SQL Server when the call is made inside
> a transaction context within MTS/COM+
> I have verified that MSDTC is started
> The DTCTester tool runs successfully
> RPC port 135 is open
> This application runs fine on a Windows 2000 Server machine with SP4.
> What is different about Windows 2000 Advanced Server such that it no
> longer works after applying security updates (SP4)'
>

MSDTC fails on Windows 2000 Advanced Server SP4

I have a VB6 application that uses MTS in a COM+ package for
transaction based processing over MSDTC. This application was working
fine when run from the SQL Server machine on Windows 2000 Advanced
Server until the latest security updates were installed. Now the
application fails to connect to SQL Server when the call is made inside
a transaction context within MTS/COM+
I have verified that MSDTC is started
The DTCTester tool runs successfully
RPC port 135 is open
This application runs fine on a Windows 2000 Server machine with SP4.
What is different about Windows 2000 Advanced Server such that it no
longer works after applying security updates (SP4)'?s your SQL server and application server are in same domain, do you have
firewall etc between SQL Server and appl. server?
We had problems after we install Windows 2003 SP1 with MSDTC, we select No
Authantication Required and the problem is gone. Maybe because of you have
applied security patches you are having the same problem.
Check out:
http://support.microsoft.com/?id=883960
Hope this helps.
"dhalb@.comcast.net" wrote:

> I have a VB6 application that uses MTS in a COM+ package for
> transaction based processing over MSDTC. This application was working
> fine when run from the SQL Server machine on Windows 2000 Advanced
> Server until the latest security updates were installed. Now the
> application fails to connect to SQL Server when the call is made inside
> a transaction context within MTS/COM+
> I have verified that MSDTC is started
> The DTCTester tool runs successfully
> RPC port 135 is open
> This application runs fine on a Windows 2000 Server machine with SP4.
> What is different about Windows 2000 Advanced Server such that it no
> longer works after applying security updates (SP4)'
>

MSDTC Fails

SQL Server 2000 servers are running on two different servers on Windows 2003.
One is part of domain but the other one is not part of any domain.
MSDTC failed to communicate with error msg 7391.
Followed the instruction as mentioned in KB-329332, but still failed.
Followed the instruction as mentioned in KB-827805 but failed too. In
KB-827805, it only tells to add the registry with value name
"TurnOffRpcSecurity". Is it the only thing to do ?
OR both server must be run under the same domain.
Can any SQL Server MVP or Microsoft technical support persons help ?
"Johnny" wrote:

> SQL Server 2000 servers are running on two different servers on Windows 2003.
> One is part of domain but the other one is not part of any domain.
> MSDTC failed to communicate with error msg 7391.
> Followed the instruction as mentioned in KB-329332, but still failed.
> Followed the instruction as mentioned in KB-827805 but failed too. In
> KB-827805, it only tells to add the registry with value name
> "TurnOffRpcSecurity". Is it the only thing to do ?
> OR both server must be run under the same domain.
>
|||Have you enabled Network COM+ and DTC access under application server on the
add\remove windows components portion of add\remove programs?
nivek
"Johnny" <Johnny@.discussions.microsoft.com> wrote in message
news:80C3DF07-4C7C-4A1E-B2B4-8D091C09B73B@.microsoft.com...
> SQL Server 2000 servers are running on two different servers on Windows
> 2003.
> One is part of domain but the other one is not part of any domain.
> MSDTC failed to communicate with error msg 7391.
> Followed the instruction as mentioned in KB-329332, but still failed.
> Followed the instruction as mentioned in KB-827805 but failed too. In
> KB-827805, it only tells to add the registry with value name
> "TurnOffRpcSecurity". Is it the only thing to do ?
> OR both server must be run under the same domain.
>
|||I also went through the KB-816701. The components Network COM+ and Network
DTC access are already enable by default.
When I put the two servers to the same domain, MSDTC works beautifully. But
why Windows 2003 has this restriction.
"nivek" wrote:

> Have you enabled Network COM+ and DTC access under application server on the
> add\remove windows components portion of add\remove programs?
> --
> nivek
>
>
> "Johnny" <Johnny@.discussions.microsoft.com> wrote in message
> news:80C3DF07-4C7C-4A1E-B2B4-8D091C09B73B@.microsoft.com...
>
>

MSDTC Fails

SQL Server 2000 servers are running on two different servers on Windows 2003.
One is part of domain but the other one is not part of any domain.
MSDTC failed to communicate with error msg 7391.
Followed the instruction as mentioned in KB-329332, but still failed.
Followed the instruction as mentioned in KB-827805 but failed too. In
KB-827805, it only tells to add the registry with value name
"TurnOffRpcSecurity". Is it the only thing to do ?
OR both server must be run under the same domain.Can any SQL Server MVP or Microsoft technical support persons help ?
"Johnny" wrote:
> SQL Server 2000 servers are running on two different servers on Windows 2003.
> One is part of domain but the other one is not part of any domain.
> MSDTC failed to communicate with error msg 7391.
> Followed the instruction as mentioned in KB-329332, but still failed.
> Followed the instruction as mentioned in KB-827805 but failed too. In
> KB-827805, it only tells to add the registry with value name
> "TurnOffRpcSecurity". Is it the only thing to do ?
> OR both server must be run under the same domain.
>|||Have you enabled Network COM+ and DTC access under application server on the
add\remove windows components portion of add\remove programs?
--
nivek
"Johnny" <Johnny@.discussions.microsoft.com> wrote in message
news:80C3DF07-4C7C-4A1E-B2B4-8D091C09B73B@.microsoft.com...
> SQL Server 2000 servers are running on two different servers on Windows
> 2003.
> One is part of domain but the other one is not part of any domain.
> MSDTC failed to communicate with error msg 7391.
> Followed the instruction as mentioned in KB-329332, but still failed.
> Followed the instruction as mentioned in KB-827805 but failed too. In
> KB-827805, it only tells to add the registry with value name
> "TurnOffRpcSecurity". Is it the only thing to do ?
> OR both server must be run under the same domain.
>|||I also went through the KB-816701. The components Network COM+ and Network
DTC access are already enable by default.
When I put the two servers to the same domain, MSDTC works beautifully. But
why Windows 2003 has this restriction.
"nivek" wrote:
> Have you enabled Network COM+ and DTC access under application server on the
> add\remove windows components portion of add\remove programs?
> --
> nivek
>
>
> "Johnny" <Johnny@.discussions.microsoft.com> wrote in message
> news:80C3DF07-4C7C-4A1E-B2B4-8D091C09B73B@.microsoft.com...
> > SQL Server 2000 servers are running on two different servers on Windows
> > 2003.
> > One is part of domain but the other one is not part of any domain.
> > MSDTC failed to communicate with error msg 7391.
> >
> > Followed the instruction as mentioned in KB-329332, but still failed.
> > Followed the instruction as mentioned in KB-827805 but failed too. In
> > KB-827805, it only tells to add the registry with value name
> > "TurnOffRpcSecurity". Is it the only thing to do ?
> >
> > OR both server must be run under the same domain.
> >
>
>

MSDTC Fails

SQL Server 2000 servers are running on two different servers on Windows 2003
.
One is part of domain but the other one is not part of any domain.
MSDTC failed to communicate with error msg 7391.
Followed the instruction as mentioned in KB-329332, but still failed.
Followed the instruction as mentioned in KB-827805 but failed too. In
KB-827805, it only tells to add the registry with value name
"TurnOffRpcSecurity". Is it the only thing to do ?
OR both server must be run under the same domain.Can any SQL Server MVP or Microsoft technical support persons help ?
"Johnny" wrote:

> SQL Server 2000 servers are running on two different servers on Windows 20
03.
> One is part of domain but the other one is not part of any domain.
> MSDTC failed to communicate with error msg 7391.
> Followed the instruction as mentioned in KB-329332, but still failed.
> Followed the instruction as mentioned in KB-827805 but failed too. In
> KB-827805, it only tells to add the registry with value name
> "TurnOffRpcSecurity". Is it the only thing to do ?
> OR both server must be run under the same domain.
>|||Have you enabled Network COM+ and DTC access under application server on the
add\remove windows components portion of add\remove programs?
nivek
"Johnny" <Johnny@.discussions.microsoft.com> wrote in message
news:80C3DF07-4C7C-4A1E-B2B4-8D091C09B73B@.microsoft.com...
> SQL Server 2000 servers are running on two different servers on Windows
> 2003.
> One is part of domain but the other one is not part of any domain.
> MSDTC failed to communicate with error msg 7391.
> Followed the instruction as mentioned in KB-329332, but still failed.
> Followed the instruction as mentioned in KB-827805 but failed too. In
> KB-827805, it only tells to add the registry with value name
> "TurnOffRpcSecurity". Is it the only thing to do ?
> OR both server must be run under the same domain.
>|||I also went through the KB-816701. The components Network COM+ and Network
DTC access are already enable by default.
When I put the two servers to the same domain, MSDTC works beautifully. But
why Windows 2003 has this restriction.
"nivek" wrote:

> Have you enabled Network COM+ and DTC access under application server on t
he
> add\remove windows components portion of add\remove programs?
> --
> nivek
>
>
> "Johnny" <Johnny@.discussions.microsoft.com> wrote in message
> news:80C3DF07-4C7C-4A1E-B2B4-8D091C09B73B@.microsoft.com...
>
>

MSDTC Event ID 53286

I have a SQL Server that keeps throwing errors in the Application Log.
I cannot seem to track these down, and I have checked Microsoft and
EventID for information. Here is the event:
Event Type: Warning
Event Source: MSDTC
Event Category: XATM
Event ID: 53286
Description:
The XA Transaction Manager called the "GetXaSwitch" function in the XA
resource manager DLL. The call to the "GetXaSwitch" function failed:
File=.\xarmdir.cpp Line=580.
Can someone shed some light on what I need to do to resolve this
problem?
Thanks in advance,
J Wolfgang GoerlichI do not know what that DLL is used for, but I would first verify using SQL
Profiler if the XA transaction makes it all the way to SQL Server, by
looking at the Distributed Transaction Event Class
BTW: If you are using Oracle 8 or 9 you should be using: "Oracle Services
for MTS in Oracle9i"
http://otn.oracle.com/tech/windows/ora_mts/htdocs/oramtsfov9i.html
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.
"jwgoerlich" <jwgoerlich@.quantaonline.com> wrote in message
news:9c87d620.0308290628.5843fe3e@.posting.google.com...
> Funny thing. I solved this one by recreating the DTC log (msdtc
> -resetlog). Now I am no longer getting that error. I did notice that
> the MTC is trying to load a ENUdtcl.dll file from the Oracle folder,
> and this file does not exist. Any one have an idea on what this is
> used for, or should I not worry about it?
> Thanks in advance,
> J Wolfgang Goerlich

MSDTC error

Hi guys,
Im new to SQL Server development in general...Well, I've been trying to
work on an existing application that uses both ASP and SQL Server that
happened to be raising an error that is logged on the Event Viewer 15
minutes after closing the browser. Here it is:
Event Type: Information
Event Source: MSDTC
Event Category: (3)
Event ID: 4156
Date: 09/08/2005
Time: 12:56:28 PM
User: N/A
Description:
String message: Session idle timeout over, tearing down the session.
As it looks, it seems like a uncleared session state upon exiting the
ASP page. I then tried using Session.Contents.RemoveAll and
Session.Abandon methods but still got no luck on the ASP side...Is there
anyway this Informational Message won't get logged into the Event
Viewer? I dont really know if its ASP or SQL problem! hehe...
Your help will greatly be appreciated. Thanks!
*** Sent via Developersdex http://www.examnotes.net ***Hope this helps.
Dan Guzman
SQL Server MVP
"jules remoreras" <losevilla@.yahoo.com> wrote in message
news:uQYosRRvFHA.2504@.tk2msftngp13.phx.gbl...
> Hi guys,
> Im new to SQL Server development in general...Well, I've been trying to
> work on an existing application that uses both ASP and SQL Server that
> happened to be raising an error that is logged on the Event Viewer 15
> minutes after closing the browser. Here it is:
> Event Type: Information
> Event Source: MSDTC
> Event Category: (3)
> Event ID: 4156
> Date: 09/08/2005
> Time: 12:56:28 PM
> User: N/A
> Description:
> String message: Session idle timeout over, tearing down the session.
> As it looks, it seems like a uncleared session state upon exiting the
> ASP page. I then tried using Session.Contents.RemoveAll and
> Session.Abandon methods but still got no luck on the ASP side...Is there
> anyway this Informational Message won't get logged into the Event
> Viewer? I dont really know if its ASP or SQL problem! hehe...
> Your help will greatly be appreciated. Thanks!
>
>
> *** Sent via Developersdex http://www.examnotes.net ***|||Check out http://support.microsoft.com/defaul...kb;en-us;290334 for
more information on the error. AFAIK, the message can't be suppressed.
Hope this helps.
Dan Guzman
SQL Server MVP
"jules remoreras" <losevilla@.yahoo.com> wrote in message
news:uQYosRRvFHA.2504@.tk2msftngp13.phx.gbl...
> Hi guys,
> Im new to SQL Server development in general...Well, I've been trying to
> work on an existing application that uses both ASP and SQL Server that
> happened to be raising an error that is logged on the Event Viewer 15
> minutes after closing the browser. Here it is:
> Event Type: Information
> Event Source: MSDTC
> Event Category: (3)
> Event ID: 4156
> Date: 09/08/2005
> Time: 12:56:28 PM
> User: N/A
> Description:
> String message: Session idle timeout over, tearing down the session.
> As it looks, it seems like a uncleared session state upon exiting the
> ASP page. I then tried using Session.Contents.RemoveAll and
> Session.Abandon methods but still got no luck on the ASP side...Is there
> anyway this Informational Message won't get logged into the Event
> Viewer? I dont really know if its ASP or SQL problem! hehe...
> Your help will greatly be appreciated. Thanks!
>
>
> *** Sent via Developersdex http://www.examnotes.net ***|||Session is holding an object it should not hold. If it is database related,
it is likely a connection opened when a session starts that is never killed.
It is not necessarily SQL Server related.
I would post in the ASP group:
microsoft.public.inetserver.asp.general
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
***************************
Think Outside the Box!
***************************
"jules remoreras" wrote:

> Hi guys,
> Im new to SQL Server development in general...Well, I've been trying to
> work on an existing application that uses both ASP and SQL Server that
> happened to be raising an error that is logged on the Event Viewer 15
> minutes after closing the browser. Here it is:
> Event Type: Information
> Event Source: MSDTC
> Event Category: (3)
> Event ID: 4156
> Date: 09/08/2005
> Time: 12:56:28 PM
> User: N/A
> Description:
> String message: Session idle timeout over, tearing down the session.
> As it looks, it seems like a uncleared session state upon exiting the
> ASP page. I then tried using Session.Contents.RemoveAll and
> Session.Abandon methods but still got no luck on the ASP side...Is there
> anyway this Informational Message won't get logged into the Event
> Viewer? I dont really know if its ASP or SQL problem! hehe...
> Your help will greatly be appreciated. Thanks!
>
>
> *** Sent via Developersdex http://www.examnotes.net ***
>|||Gee...thanks to both of you (Dan and Cowboy) for the input!!! :) At
least the input/link you posted somehow enlighten my heavily burden
mind. hehehe. Thanks again!
*** Sent via Developersdex http://www.examnotes.net ***

MSDTC Error

MSDTC error

Hi,
I have econnection code in front end app to do the update. I got the
following error,
The transaction manager has disabled its support for remote/network
transaction...
I checked app server the MSDTC has enabled
Any ideas why?
ThanksRead the replies...think youre answer in there.
Just google my friend ;)
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=230390&SiteID=1
First verify the "Distribute Transaction Coordinator" Service is
running on both database server computer and client computers
1. Go to "Administrative Tools > Services"
2. Turn on the "Distribute Transaction Coordinator" Service if it is
not running
If it is running and client application is not on the same computer as
the database server, on the computer running database server
1. Go to "Administrative Tools > Component Services"
2. On the left navigation tree, go to "Component Services > Computers
> My Computer" (you may need to double click and wait as some nodes
need time to expand)
3. Right click on "My Computer", select "Properties"
4. Select "MSDTC" tab
5. Click "Security Configuration"
6. Make sure you check "Network DTC Access", "Allow Remote Client",
"Allow Inbound/Outbound", "Enable TIP" (Some option may not be
necessary, have a try to get your configuration)
7. The service will restart
8. BUT YOU MAY NEED TO REBOOT YOUR SERVER IF IT STILL DOESN'T WORK
(This is the thing drove me crazy before)
On your client computer use the same above procedure to open the
"Security Configuration" setting, make sure you check "Network DTC
Access", "Allow Inbound/Outbound" option, restart service and computer
if necessary.
On you SQL server service manager, click "Service" dropdown, select
"Distribute Transaction Coordinator", it should be also running on
your server computer.
Hope it helps,|||the server is virtual server running window 2000 terminal
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23myijFJ8HHA.1484@.TK2MSFTNGP06.phx.gbl...
> Hi,
> I have econnection code in front end app to do the update. I got the
> following error,
> The transaction manager has disabled its support for remote/network
> transaction...
> I checked app server the MSDTC has enabled
> Any ideas why?
> Thanks
>

MSDTC Error

Setup: Win2K Server, SQL server 2000 sp4
"Microsoft OLE DB Provider for SQL Server error '8004d00a'
New transaction cannot enlist in the specified transaction coordinator. "
I've seen the KB atricles if you have this problem on server 2003 but the
items in the steps don't exist in win 2k server.
(http://support.microsoft.com/default.aspx?scid=kb;en-us;329332&Product=sql)Hi Ben
Did you check out the information on the related article
http://support.microsoft.com/kb/306843/ ?
Is this using a linked server?
John
"Ben" wrote:
> Setup: Win2K Server, SQL server 2000 sp4
> "Microsoft OLE DB Provider for SQL Server error '8004d00a'
> New transaction cannot enlist in the specified transaction coordinator. "
> I've seen the KB atricles if you have this problem on server 2003 but the
> items in the steps don't exist in win 2k server.
> (http://support.microsoft.com/default.aspx?scid=kb;en-us;329332&Product=sql)
>
>
>|||I am also having Linked Server.
but not able to get out of this problem
"John Bell" wrote:
> Hi Ben
> Did you check out the information on the related article
> http://support.microsoft.com/kb/306843/ ?
> Is this using a linked server?
> John
> "Ben" wrote:
> > Setup: Win2K Server, SQL server 2000 sp4
> >
> > "Microsoft OLE DB Provider for SQL Server error '8004d00a'
> > New transaction cannot enlist in the specified transaction coordinator. "
> >
> > I've seen the KB atricles if you have this problem on server 2003 but the
> > items in the steps don't exist in win 2k server.
> > (http://support.microsoft.com/default.aspx?scid=kb;en-us;329332&Product=sql)
> >
> >
> >
> >
> >|||Hi
Have you verified that DTC is working correctly? Have you tried using DTCPing?
John
"Labhesh Shrimali - Bangalore" wrote:
> I am also having Linked Server.
> but not able to get out of this problem
> "John Bell" wrote:
> > Hi Ben
> >
> > Did you check out the information on the related article
> > http://support.microsoft.com/kb/306843/ ?
> >
> > Is this using a linked server?
> >
> > John
> >
> > "Ben" wrote:
> >
> > > Setup: Win2K Server, SQL server 2000 sp4
> > >
> > > "Microsoft OLE DB Provider for SQL Server error '8004d00a'
> > > New transaction cannot enlist in the specified transaction coordinator. "
> > >
> > > I've seen the KB atricles if you have this problem on server 2003 but the
> > > items in the steps don't exist in win 2k server.
> > > (http://support.microsoft.com/default.aspx?scid=kb;en-us;329332&Product=sql)
> > >
> > >
> > >
> > >
> > >

MSDTC doesn't work on SQL 2k in W2k3 cluster environment

Hi,
I have moved our cluster SQL 2k server from a W2k cluster to a new w2k3 SP1
cluster server recently. After the move, I found two applications that use
MSDTC didn't work. I realized that I made a mistake when I setup the MSDTC, I
didn't enable network DTC access on both nodes before I configured MSDTC and
then installed the SQL server. To remedy this problem, I deleted the MSDTC
resource in the cluster admin, and reconfigured it again after enable the
network DTC access on both nodes. However, the MSDTC on the cluster still
doesn't work. The installation sequence should configure MSDTC first, then
install SQL2K. Does this sequence matter? Do I have to reinstall the SQL
server to get MSDTC work?
I use DTCTester and get following error:
Initializing DTC
Beginning DTC Transaction
Enlisting Connection in Transaction
Error:
SQLSTATE=37000,Native error=8501,msg='[Microsoft][ODBC SQL Server
Driver][SQL Se
rver]MSDTC on server 'AWIDB1' is unavailable.'
Error:
SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid
cur
sor state
Typical Errors in DTC Output When
a. Firewall Has Ports Closed
-OR-
b. Bad WINS/DNS entries
-OR-
c. Misconfigured network
-OR-
d. Misconfigured SQL Server machine that has multiple netcards.
Aborting DTC Transaction
Releasing DTC Interface Pointers
Successfully Released pTransaction Pointer.
Thanks in advance.
Never mind. it worked. I should restart the SQL server after re-configured
the MSDTC resource. Since this server has been in production already, I just
wished that every changes would take effect dynamically.
"Jack Zhang" wrote:

> Hi,
> I have moved our cluster SQL 2k server from a W2k cluster to a new w2k3 SP1
> cluster server recently. After the move, I found two applications that use
> MSDTC didn't work. I realized that I made a mistake when I setup the MSDTC, I
> didn't enable network DTC access on both nodes before I configured MSDTC and
> then installed the SQL server. To remedy this problem, I deleted the MSDTC
> resource in the cluster admin, and reconfigured it again after enable the
> network DTC access on both nodes. However, the MSDTC on the cluster still
> doesn't work. The installation sequence should configure MSDTC first, then
> install SQL2K. Does this sequence matter? Do I have to reinstall the SQL
> server to get MSDTC work?
> I use DTCTester and get following error:
> Initializing DTC
> Beginning DTC Transaction
> Enlisting Connection in Transaction
> Error:
> SQLSTATE=37000,Native error=8501,msg='[Microsoft][ODBC SQL Server
> Driver][SQL Se
> rver]MSDTC on server 'AWIDB1' is unavailable.'
> Error:
> SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid
> cur
> sor state
> Typical Errors in DTC Output When
> a. Firewall Has Ports Closed
> -OR-
> b. Bad WINS/DNS entries
> -OR-
> c. Misconfigured network
> -OR-
> d. Misconfigured SQL Server machine that has multiple netcards.
> Aborting DTC Transaction
> Releasing DTC Interface Pointers
> Successfully Released pTransaction Pointer.
> Thanks in advance.
|||You are correct in that you should have followed the correct and documented
installation sequence; however, you should be able to do it after the fact.
Also know that there is a COM 1.5 bug in Windows 2003.
First, after reclustering the MSDTC, did you configure it within its own
dedicated Cluster Resource Group? It will require the creation of this
group, a dedicated SAN disk, IP, and Network Name cluster resources. Then,
you will need to fail that resource back and forth between the nodes to get
the resource registry entries to synchronize.
You will then need to take the SQL Server IP resource offline, which should
bring the resources in that group offline and then bring the group back
online.
In the SQL Server Error Log, you will see SQL Server attempting to connect
to the DTC resource; if it opens the connection, there will be no additional
messages. If it has a problem however, it will spit out a "Could not
generate resource context" type of error message. That will tell you if
this worked or not.
If this process fails, one other option would be to run through the ADVANCED
section of the SQL Server installation processes. This should
verify/generate the necessary registry key dependencies without having to
completely reinstall.
If this too does not solve the problem, then before you uninstall/reinstall,
I would seriously consider opening a Microsoft Product Support Services
case, MS PSS.
INFO: Availability of Windows Server 2003 COM+ 1.5 Rollup Package 1
http://support.microsoft.com/kb/821751/
You receive error messages when you perform a distributed transaction when
you have a SQL Server 2000 virtual server in a Windows Server 2003 clustered
environment
http://support.microsoft.com/default...b;en-us;889706
How to rebuild or move MSDTC used with a SQL failover cluster
http://support.microsoft.com/default...b;en-us;294209
How to configure Microsoft Distributed Transaction Coordinator on a Windows
Server 2003 cluster
http://support.microsoft.com/kb/301600/
How to enable network DTC access in Windows Server 2003
http://support.microsoft.com/kb/817064/
Good luck and be sure to let us know how it turns out.
Sincerely,
Anthony Thomas

"Jack Zhang" <JackZhang@.discussions.microsoft.com> wrote in message
news:46C965C9-5431-460C-92ED-DE5873B57E2F@.microsoft.com...
> Hi,
> I have moved our cluster SQL 2k server from a W2k cluster to a new w2k3
SP1
> cluster server recently. After the move, I found two applications that use
> MSDTC didn't work. I realized that I made a mistake when I setup the
MSDTC, I
> didn't enable network DTC access on both nodes before I configured MSDTC
and
> then installed the SQL server. To remedy this problem, I deleted the MSDTC
> resource in the cluster admin, and reconfigured it again after enable the
> network DTC access on both nodes. However, the MSDTC on the cluster still
> doesn't work. The installation sequence should configure MSDTC first, then
> install SQL2K. Does this sequence matter? Do I have to reinstall the SQL
> server to get MSDTC work?
> I use DTCTester and get following error:
> Initializing DTC
> Beginning DTC Transaction
> Enlisting Connection in Transaction
> Error:
> SQLSTATE=37000,Native error=8501,msg='[Microsoft][ODBC SQL Server
> Driver][SQL Se
> rver]MSDTC on server 'AWIDB1' is unavailable.'
> Error:
> SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server
Driver]Invalid
> cur
> sor state
> Typical Errors in DTC Output When
> a. Firewall Has Ports Closed
> -OR-
> b. Bad WINS/DNS entries
> -OR-
> c. Misconfigured network
> -OR-
> d. Misconfigured SQL Server machine that has multiple netcards.
> Aborting DTC Transaction
> Releasing DTC Interface Pointers
> Successfully Released pTransaction Pointer.
> Thanks in advance.
|||Did you set the security on MSDTC through the Component Services Applet?
That is a necessary step after all the steps you listed.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Jack Zhang" <JackZhang@.discussions.microsoft.com> wrote in message
news:46C965C9-5431-460C-92ED-DE5873B57E2F@.microsoft.com...
> Hi,
> I have moved our cluster SQL 2k server from a W2k cluster to a new w2k3
> SP1
> cluster server recently. After the move, I found two applications that use
> MSDTC didn't work. I realized that I made a mistake when I setup the
> MSDTC, I
> didn't enable network DTC access on both nodes before I configured MSDTC
> and
> then installed the SQL server. To remedy this problem, I deleted the MSDTC
> resource in the cluster admin, and reconfigured it again after enable the
> network DTC access on both nodes. However, the MSDTC on the cluster still
> doesn't work. The installation sequence should configure MSDTC first, then
> install SQL2K. Does this sequence matter? Do I have to reinstall the SQL
> server to get MSDTC work?
> I use DTCTester and get following error:
> Initializing DTC
> Beginning DTC Transaction
> Enlisting Connection in Transaction
> Error:
> SQLSTATE=37000,Native error=8501,msg='[Microsoft][ODBC SQL Server
> Driver][SQL Se
> rver]MSDTC on server 'AWIDB1' is unavailable.'
> Error:
> SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server
> Driver]Invalid
> cur
> sor state
> Typical Errors in DTC Output When
> a. Firewall Has Ports Closed
> -OR-
> b. Bad WINS/DNS entries
> -OR-
> c. Misconfigured network
> -OR-
> d. Misconfigured SQL Server machine that has multiple netcards.
> Aborting DTC Transaction
> Releasing DTC Interface Pointers
> Successfully Released pTransaction Pointer.
> Thanks in advance.

MSDTC Doesn't seem to work

Hi,
I have a 2 node SQL 2000 Cluster
When I run the dtctester.exe I run into the following error :
================================================== ===
DSN: dtctest
User Name: ******
Password: ******
tablename= #dtc24358
Creating Temp Table for Testing: #dtc24358
Warning: No Columns in Result Set From Executing: 'create table #dtc24358
(ival int)'
Initializing DTC
Beginning DTC Transaction
Enlisting Connection in Transaction
Error:
SQLSTATE=25S12,Native error=-2147168242,msg='[Microsoft][ODBC SQL Server
Driver]Distributed transaction error'
Error:
SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid
cursor state
Typical Errors in DTC Output When
a. Firewall Has Ports Closed
-OR-
b. Bad WINS/DNS entries
-OR-
c. Misconfigured network
-OR-
d. Misconfigured SQL Server machine that has multiple netcards.
Aborting DTC Transaction
Releasing DTC Interface Pointers
Successfully Released pTransaction Pointer.
================================================== ====
Any help is greatly appreciated. Thanks a Lot.
Regards,
Vick
Just a quick note on it... I'm running the dtctester.exe from a different
box... So I give the sql ip address and user/passwd..
"Vick Shaw" <nospam@.msft.com> wrote in message
news:elTzA1GUHHA.868@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I have a 2 node SQL 2000 Cluster
> When I run the dtctester.exe I run into the following error :
> ================================================== ===
> DSN: dtctest
> User Name: ******
> Password: ******
> tablename= #dtc24358
> Creating Temp Table for Testing: #dtc24358
> Warning: No Columns in Result Set From Executing: 'create table #dtc24358
> (ival int)'
> Initializing DTC
> Beginning DTC Transaction
> Enlisting Connection in Transaction
> Error:
> SQLSTATE=25S12,Native error=-2147168242,msg='[Microsoft][ODBC SQL Server
> Driver]Distributed transaction error'
> Error:
> SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server
Driver]Invalid
> cursor state
> Typical Errors in DTC Output When
> a. Firewall Has Ports Closed
> -OR-
> b. Bad WINS/DNS entries
> -OR-
> c. Misconfigured network
> -OR-
> d. Misconfigured SQL Server machine that has multiple netcards.
> Aborting DTC Transaction
> Releasing DTC Interface Pointers
> Successfully Released pTransaction Pointer.
> ================================================== ====
> Any help is greatly appreciated. Thanks a Lot.
> Regards,
> Vick
>
|||You need to properly configure DTC for Cluster and Network Connections:
http://support.microsoft.com/kb/817064/
http://support.microsoft.com/kb/301600
If you are running Win2K3 SP1, you will need to reset the DTC security
parameters:
http://support.microsoft.com/kb/899191
Since you are beginning the transaction on a remote host, that host will
also need to properly configure its DTC services.
Finally, if the communication must transit any firewalls, then you will need
to restrict RPC ports on both Client and Server for Internet Ports, and then
authorize these Ports in the firewall ACLs.
http://support.microsoft.com/kb/300083
http://support.microsoft.com/kb/250367/EN-US/
Because we authorize much of the Remote Administration utilities outbound
with an outgoing trust from our secured network, we typically configure this
restricted range to 50005100.
Good luck.
Anthony Thomas

"Vick Shaw" <nospam@.msft.com> wrote in message
news:Oo9Vr2GUHHA.4188@.TK2MSFTNGP06.phx.gbl...[vbcol=seagreen]
> Just a quick note on it... I'm running the dtctester.exe from a different
> box... So I give the sql ip address and user/passwd..
> "Vick Shaw" <nospam@.msft.com> wrote in message
> news:elTzA1GUHHA.868@.TK2MSFTNGP05.phx.gbl...
#dtc24358
> Driver]Invalid
>
|||Thanks Anthony,
After reading the KB I realize that I installed MSDTC manually on both the
cluster node by Add/Remove Widows Compenet. If I uninstall the DTC the same
way and reinstall thru the Cluster Admin it should work right ?
Thanks again..
Vick
"Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
news:u1EiXhQUHHA.4632@.TK2MSFTNGP04.phx.gbl...
> You need to properly configure DTC for Cluster and Network Connections:
> http://support.microsoft.com/kb/817064/
> http://support.microsoft.com/kb/301600
> If you are running Win2K3 SP1, you will need to reset the DTC security
> parameters:
> http://support.microsoft.com/kb/899191
> Since you are beginning the transaction on a remote host, that host will
> also need to properly configure its DTC services.
> Finally, if the communication must transit any firewalls, then you will
need
> to restrict RPC ports on both Client and Server for Internet Ports, and
then
> authorize these Ports in the firewall ACLs.
> http://support.microsoft.com/kb/300083
> http://support.microsoft.com/kb/250367/EN-US/
> Because we authorize much of the Remote Administration utilities outbound
> with an outgoing trust from our secured network, we typically configure
this[vbcol=seagreen]
> restricted range to 5000-5100.
> Good luck.
>
> Anthony Thomas
>
> --
> "Vick Shaw" <nospam@.msft.com> wrote in message
> news:Oo9Vr2GUHHA.4188@.TK2MSFTNGP06.phx.gbl...
different[vbcol=seagreen]
> #dtc24358
Server
>
|||I appologize for breaking up the response in two mails.
I enabled DTC access on both the nodes using add/remove Programs but I added
the MSDTC as a cluster resource thru the cluster Admin console... I've also
applied the required Registry settings for MSDTC (security) but still I'm
not able to get it working. Alos there are no firewalls ...
Thanks again..
Vick.
"Vick Shaw" <nospam@.msft.com> wrote in message
news:OklJjJRUHHA.4796@.TK2MSFTNGP05.phx.gbl...
> Thanks Anthony,
> After reading the KB I realize that I installed MSDTC manually on both the
> cluster node by Add/Remove Widows Compenet. If I uninstall the DTC the
same[vbcol=seagreen]
> way and reinstall thru the Cluster Admin it should work right ?
> Thanks again..
> Vick
>
> "Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
> news:u1EiXhQUHHA.4632@.TK2MSFTNGP04.phx.gbl...
> need
> then
outbound
> this
> different
> Server
>

MSDTC connection problem

Hello, I have a very annoying problem:
The Lan network comprises:
A) SQL Server 2005 Express Edition (WindowsXP Sp2)
B) SQL Server 2005 Standard Edition (Windows 2003 Server Sp2)
When I try to run distributed transaction from *A* to *B*, I receive
the error message:
"Transakcja zostaa ju jawnie lub niejawnie przekazana
lub przerwana"
(my translation is: Transaction has been explicitly or
implicitly interrupted or transfered)
When I try to run distributed transaction from *B* to *A*, I receive
the error message:
"No transaction is active."
The transaction is simple, similar to:
begin distributed tran
SELECT * FROM SerwerA.testowa.dbo.tabela;
commit
MSDTC is running on both computers, properly configured (network-aware),
there are no firewalls running, server names are resolvable (they're
placed in the hosts files). What could be the reason for such a
behaviour? I'd be grateful for any kind of help because I'm fighting
with this problem for a few days...
Regards,
Piotr
Piotr Porzucek wrote:
> Hello, I have a very annoying problem:
> The Lan network comprises:
> A) SQL Server 2005 Express Edition (WindowsXP Sp2)
> B) SQL Server 2005 Standard Edition (Windows 2003 Server Sp2)
> When I try to run distributed transaction from *A* to *B*, I receive
> the error message:
> "Transakcja zostaa ju jawnie lub niejawnie przekazana
> lub przerwana"
> (my translation is: Transaction has been explicitly or
> implicitly interrupted or transfered)
> When I try to run distributed transaction from *B* to *A*, I receive
> the error message:
> "No transaction is active."
> The transaction is simple, similar to:
> begin distributed tran
> SELECT * FROM SerwerA.testowa.dbo.tabela;
> commit
> MSDTC is running on both computers, properly configured (network-aware),
> there are no firewalls running, server names are resolvable (they're
> placed in the hosts files). What could be the reason for such a
> behaviour? I'd be grateful for any kind of help because I'm fighting
> with this problem for a few days...
> Regards,
> Piotr
Hi,
Try to take a look at this link - maybe that can lead you on right track.
http://support.microsoft.com/kb/817064/
Regards
Steen Schlter Persson
Database Administrator / System Administrator

MSDTC connection problem

Hello, I have a very annoying problem:
The Lan network comprises:
A) SQL Server 2005 Express Edition (WindowsXP Sp2)
B) SQL Server 2005 Standard Edition (Windows 2003 Server Sp2)
When I try to run distributed transaction from *A* to *B*, I receive
the error message:
"Transakcja zosta³a ju¿ jawnie lub niejawnie przekazana
lub przerwana"
(my translation is: Transaction has been explicitly or
implicitly interrupted or transfered)
When I try to run distributed transaction from *B* to *A*, I receive
the error message:
"No transaction is active."
The transaction is simple, similar to:
begin distributed tran
SELECT * FROM SerwerA.testowa.dbo.tabela;
commit
MSDTC is running on both computers, properly configured (network-aware),
there are no firewalls running, server names are resolvable (they're
placed in the hosts files). What could be the reason for such a
behaviour? I'd be grateful for any kind of help because I'm fighting
with this problem for a few days...
Regards,
PiotrPiotr Porzucek wrote:
> Hello, I have a very annoying problem:
> The Lan network comprises:
> A) SQL Server 2005 Express Edition (WindowsXP Sp2)
> B) SQL Server 2005 Standard Edition (Windows 2003 Server Sp2)
> When I try to run distributed transaction from *A* to *B*, I receive
> the error message:
> "Transakcja zosta³a ju¿ jawnie lub niejawnie przekazana
> lub przerwana"
> (my translation is: Transaction has been explicitly or
> implicitly interrupted or transfered)
> When I try to run distributed transaction from *B* to *A*, I receive
> the error message:
> "No transaction is active."
> The transaction is simple, similar to:
> begin distributed tran
> SELECT * FROM SerwerA.testowa.dbo.tabela;
> commit
> MSDTC is running on both computers, properly configured (network-aware),
> there are no firewalls running, server names are resolvable (they're
> placed in the hosts files). What could be the reason for such a
> behaviour? I'd be grateful for any kind of help because I'm fighting
> with this problem for a few days...
> Regards,
> Piotr
Hi,
Try to take a look at this link - maybe that can lead you on right track.
http://support.microsoft.com/kb/817064/
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator

MSDTC connection problem

Hello, I have a very annoying problem:
The Lan network comprises:
A) SQL Server 2005 Express Edition (WindowsXP Sp2)
B) SQL Server 2005 Standard Edition (Windows 2003 Server Sp2)
When I try to run distributed transaction from *A* to *B*, I receive
the error message:
"Transakcja zostaa ju jawnie lub niejawnie przekazana
lub przerwana"
(my translation is: Transaction has been explicitly or
implicitly interrupted or transfered)
When I try to run distributed transaction from *B* to *A*, I receive
the error message:
"No transaction is active."
The transaction is simple, similar to:
begin distributed tran
SELECT * FROM SerwerA.testowa.dbo.tabela;
commit
MSDTC is running on both computers, properly configured (network-aware),
there are no firewalls running, server names are resolvable (they're
placed in the hosts files). What could be the reason for such a
behaviour? I'd be grateful for any kind of help because I'm fighting
with this problem for a few days...
Regards,
PiotrPiotr Porzucek wrote:
> Hello, I have a very annoying problem:
> The Lan network comprises:
> A) SQL Server 2005 Express Edition (WindowsXP Sp2)
> B) SQL Server 2005 Standard Edition (Windows 2003 Server Sp2)
> When I try to run distributed transaction from *A* to *B*, I receive
> the error message:
> "Transakcja zostaa ju jawnie lub niejawnie przekazana
> lub przerwana"
> (my translation is: Transaction has been explicitly or
> implicitly interrupted or transfered)
> When I try to run distributed transaction from *B* to *A*, I receive
> the error message:
> "No transaction is active."
> The transaction is simple, similar to:
> begin distributed tran
> SELECT * FROM SerwerA.testowa.dbo.tabela;
> commit
> MSDTC is running on both computers, properly configured (network-aware),
> there are no firewalls running, server names are resolvable (they're
> placed in the hosts files). What could be the reason for such a
> behaviour? I'd be grateful for any kind of help because I'm fighting
> with this problem for a few days...
> Regards,
> Piotr
Hi,
Try to take a look at this link - maybe that can lead you on right track.
http://support.microsoft.com/kb/817064/
Regards
Steen Schlter Persson
Database Administrator / System Administrator

MSDTC configuration problem

Hi.
My application needs to do distributed transaction on remote Sql server.My
application can be run from workstations(XP professional) or from SQL server
2000...
Limitations for this application are
Worksations wont be having SQL server installed.
I cannot give administrative rights on the SQL server 2000 system( i can
give administrative rights in the SQL server itself but not for the whole
server system)
I created a sample application which has a class for doing distributed
transactions which is derived from ServicedComponent. This application when
run on SQL server 2000 runs fine.It runs fine when worksation also has SQl
server.
But i tried to run this application from a worksation where SQL server is
not installed it doesnt work.Then i configured workstations MTC to point to
remote server and when i created workstaion's login on the server machine as
administrator then the application works...but if i remove the administrator
rights on the system it doesnt...I read in the article TO CONFIGURE MSDTC
needs administrative rights on the server as well as the client.But after
configuration is over i removed the administrative right and kept it as
Standard user or restricted user it doesnt work.But since Our system cannot
give administrative logins for all the clients this would not work.

> is there any other way to make this work!!
Hello,
Did you give the workstation login the appropriate permisssions in SQL
Server? Did you tried to use SQL account to login?
Thanks,
Mohamed Sharaf
MEA Developer Support Center
ITWorx on behalf Microsoft EMEA GTSC

Saturday, February 25, 2012

Blog Archive

About Me