Seriously is there not 1 person who can fix this.

[MrHelpMe]

Please is there anybody who can help.

I have two servers. Server x running SQL Server 7.00.1063 and server y running sql server 2000 sp 3(or ver 8.00.760 sp3. Operating system for SQL server 7.00 is Windows NT and for SQL Server 2000 it's Windows 2000.

Now when I run under query analyer on server y the following query
SET XACT_ABORT ON

BEGIN Tran
SELECT b.DepartmentID
FROM CFG_TT_CT_Department b, Remedy.ARSystem.dbo.SHR_People c
WHERE c.Login_Name = 'jsmith'
AND c.Department = b.Department
Commit Tran

I get

Server: Msg 7391, Level 16, State 1, Line 4
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d00a].

If I remove the Begin Tran and Commit it works. Now I need the BEGIN and Commit because Remedy ARS usings this. Irregardless, could someone tell me why it is not running in SQL Query. I have all the linked servers correcly setup. Is there anybody that can troubleshoot this. There has to be 1 person.

Thx.

 

[SQLDenis]

Is DTC running?

also check

http://support.microsoft.com/default.aspx?scid=kb;en-us;306212

and

http://support.microsoft.com/default.aspx?scid=kb;en-us;817064

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[SQLBill]

Sorry that I can't help you with this...but I would like to comment on your choice of subject lines. You may not have meant it this way, but it comes across slightly rude. You are implying that you asked this question before and no one answered you. But checking this forum (SQL Server: Programming), you have only made two posts and this is the FIRST time you have posted this question.

You should have used a title like "Problem with DTS" or something similar.

Just something to think about next time.

-SQLBill

Posting advice: FAQ481-4875

 

[mrdenny]

Make sure that DTC is enabled and running on both servers. Try using BEGIN DISTRIBUTED TRANSACTION instead of BEGIN TRAN.

You may need to loosen up the security of the DTC on the Windows 2000 server. It's that server is fully pathed then the security may be higher than expected.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com