All Questions
13 questions
0
votes
0
answers
380
views
Deadlock Detection in Distributed Systems: Deadlock victim not recognised when using two different SQL-Server on different machines
I have a reproducible case where NO deadlock victim is detected.
The configuration is as follows:
Database 1 runs on SQL Server 1 on Machine 1
Database 2 runs on SQL Server 2 on Machine 2
The MSDTCs ...
0
votes
1
answer
804
views
Microsoft Distributed Transaction Coordinator (DTC) not honoring timeout
A test method that is responsible for testing different SQL Server instances database combinations against each other for DTC support during startup of a windows server is shown below.
However we want ...
- 5,594
0
votes
0
answers
1k
views
Is there any way to rollback transactions in SSIS for SQL Server 2012?
Cannot successfully execute an SSIS package with BEGIN TRAN functionality.
I'm at a loss with an SSIS package I inherited. It contains:
1 Script Task
3 Execute SQL tasks
5 Data flow tasks (each ...
- 1
0
votes
0
answers
72
views
Reliability of distributed transcations
Can someone please explain to me how this works? what would happen if upon commiting, one of the participants of the distributed transaction loses it's connection? How would the other participants ...
- 2,315
0
votes
1
answer
408
views
MSDTC Error - Call to RpcMgmtInqServerPrincName failed. The partner does not support secure calls
I'm trying to get MSDTC and SQL Server to work together on Windows 10 Pro. I started the Distributed Transaction Coordinator service and it is using the Network Service account. Whenever I begin a ...
2
votes
2
answers
1k
views
SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER for distributed transactions
I am trying to set dataflow tasks in a sequence container from SourceDb(exists on my local machine) to TargetDb(exists on azure & can be accessible from SSMS).
I am getting following error ...
- 348
0
votes
1
answer
2k
views
MSDTC error when running query in a transaction for a Linked SQL server
I have a linked SQL server (the two servers are on two separate continents and connected via VPN). When running the following sql, it returns the data without issue:
Select TOP 1 * from [LinkedServer]...
- 1,396
2
votes
1
answer
1k
views
How to use MSDTC with the same netbios names?
I have a database storage in a windows server 2003 and multiple databases in different windows servers in different cities.
I want to collect data from different servers in to my database storage.
I ...
- 2,516
0
votes
2
answers
2k
views
Msg 7391 The operation could not be performed because OLE DB provider for linked server was unable to begin a distributed transaction
There is 3 Sql Server. Example Server A, Server B and Server C.
-DTC is running in all the machine.
-Local DTC Properties in all three machine:
-Network DTC Access
-Allow Inbound
...
22
votes
7
answers
117k
views
The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server was unable to begin a distributed transaction [duplicate]
I'm trying to run a distributed transaction from my machine (SQL Server 2012) to a client server (SQL Server 2008).
I'm trying to run:
begin distributed transaction
select * from [172.01.01.01].master....
- 2,822
1
vote
0
answers
755
views
Inserting row from MSSQL to MySQL
I have set up a linked server with the MSDASQL provider in MSSQL to connect to a MySQL instance. I have installed and configured the MySQL ODBC 5.1 Driver connector. Everything seems to work fine to ...
- 1,236
108
votes
11
answers
229k
views
Unable to begin a distributed transaction
I'm trying to run SQL against a linked server, but I get the errors below :
BEGIN DISTRIBUTED TRANSACTION
SELECT TOP 1 * FROM Sessions
OLE DB provider "SQLNCLI" for linked server "...
- 256k
0
votes
2
answers
1k
views
Force MSDTC to orphan a SQLServer distributed transaction
When shutting down my project's WebSphere-based JavaEE application, distributed transactions are sometimes left alive in the SQLServer 2005 database. These retain their locks forever and must be ...
- 38.9k