Diagnose SQL Server Transaction Error on Windows 2003
Budget: $25 – $50 USD
I'm facing a critical issue with an old application on my Windows 2003 server. The system throws the error message: "New transaction cannot enlist in the specified transaction coordinator. ; Error Message = Unable to enlist in the transaction." This problem arises during database transactions.
The application uses SQL Server. Prior to this issue, a server change was made. The MS DTC (Microsoft Distributed Transaction Coordinator) service on the server is confirmed to be running.
I require assistance exclusively with diagnosing and resolving this transaction error. My immediate priority is to restore functionality to the application, without the need for ongoing maintenance at this time.
Ideal skills and experience:
- Seasoned Database Administrator
- Extensive experience with Windows 2003 servers
- Proficiency with SQL Server
- Proficiency with COM+
- Familiarity with database transaction intricacies
The application uses SQL Server. Prior to this issue, a server change was made. The MS DTC (Microsoft Distributed Transaction Coordinator) service on the server is confirmed to be running.
I require assistance exclusively with diagnosing and resolving this transaction error. My immediate priority is to restore functionality to the application, without the need for ongoing maintenance at this time.
Ideal skills and experience:
- Seasoned Database Administrator
- Extensive experience with Windows 2003 servers
- Proficiency with SQL Server
- Proficiency with COM+
- Familiarity with database transaction intricacies