Unable To Initiate A Distributed Transaction From Sql Server on Windows 2003 SP1
Applies to:
Oracle Provider for OLE DB - Version: 9.2 to 10.2Microsoft Windows Server 2003
Checked for relevance on 16-May-2007
Symptoms
On MS SQL Server a Linked Server to the Oracle Database using OLE DB cannot initiate a Distributed Transaction returning this error:
Server: Msg 7391, Level 16, State 1, Line 5
The operation could not be performed because the OLE DB provider 'MSDAORA' was
unable to begin a distributed transaction.
OLE DB error trace [OLE/DB Provider 'MSDAORA' ITransactionJoin::JoinTransaction
returned 0x8000d048]."
Cause
There is a change introduced by the Service Pack1 regarding the MSDTC behaviour:
The XA Transactions mechanism is passed from enabled by default to disabled by default.
Without XA Transactions enabled, no Distributed transaction to a target using XA could be initiated
See for more information.
Solution
To implement the solution follow this steps:
1.Open Component Services.
2.Expand the tree view to locate the computer where you want to turn on support for XA transactions (for example, My Computer).
3.Right-click the computer name, and then click Properties.
4.Click the MSDTC tab, and then click Security Configuration.
5.Under Security Settings, click to select the check box for XA Transactions to turn on this support.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-598370/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Windows 2003 SP1 DDK下載Windows
- Connect SQL Server from Linux Client using Windows Authentication and troubleshoot stepsSQLServerLinuxclientWindows
- MySQL案例04:Cause: java.sql.SQLException: Could not retrieve transaction read-only status from serverMySqlJavaExceptionServer
- Sql Server Linux(Redhat) Distributed Availability Group Setup — step by stepSQLServerLinuxRedhatAI
- 解決angular安裝 unable to access 'https:github...' Empty reply from serverAngularHTTPGithubServer
- Unable to execute SonarScanner analysis: Fail to get bootstrap index from server: Host is unreachable(Host unreachable)AIbootIndexServer
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:DISTRIBUTED引數SQLServer
- 檢視windows server 2003 是32位還是64位WindowsServer
- 能否在Windows Server 2003上載入Oracle 8XIWindowsServerOracle
- Windows XP系統和Windows Server 2003系統原始碼遭洩露WindowsServer原始碼
- Windows 下 Laravel 7.0 連線 sql serverWindowsLaravelSQLServer
- [已解決] [HiveCatalog]Kerberos GSS initiate failed, No valid credentials provided, Cannot read from System.inHiveROSAIIDE
- Windows 系統 SQL Server 配置使用安全模式WindowsSQLServer模式
- MySQL 2003 - Can’t connect to MySQL server on (10060)MySqlServer
- server2003安裝金鑰 server金鑰序列號Server
- windows 2003 禁止UDP的batWindowsUDPBAT
- 資料庫事務耗時過長導致Could not retrieve transaction read-only status from server異常資料庫Server
- find the replications and articles from distribution serverServer
- checkboxList operate in windows fromWindows
- Windows Server和SQL Server客戶繼續選擇Azure的三個原因WindowsServerSQL
- sql serverSQLServer
- Unable to read TLD "META-INF/c.tld" from JAR fileJAR
- [20231003]windows 2003無法啟動.txtWindows
- windows2003 DHCP伺服器配置Windows伺服器
- windows 2003伺服器 取消ping功能Windows伺服器
- MySQL5.7 Unable to find a match: MySQL-community-serverMySqlUnityServer
- Windows server 2003環境下,安裝Oracle的時候,雙擊Setup沒有任何的反應WindowsServerOracle
- 在 Visual Studio 2022 中,開發 ASP.NET 網站並在 Windows Server 2003 中進行部署ASP.NET網站WindowsServer
- how to move a MediaWiki wiki from one server to anotherServer
- Moebius for SQL ServerSQLServer
- sql server 使用SQLServer
- SQL Server教程SQLServer
- office2003金鑰序列號最新 windows2003產品金鑰萬能Windows
- Unable to download data from https://gems.ruby-china.org/ - bad response Not Found 404HTTP
- 【論文筆記】A Survey on Federated Learning: The Journey From Centralized to Distributed On-Site Learning and Beyond(綜述)筆記Zed
- 【等待事件】SQL*Net message from dblink事件SQL
- win2003r2標準版金鑰 windows2003產品金鑰永久Windows
- 【問題解決】java.sql.SQLException: null, message from server: “Host ‘xxx.xx.xx.xxx‘ is blocked because ofJavaSQLExceptionNullServerBloC
- Windows 2003自帶效能監控工具的使用Windows