Friday, March 30, 2012

Problem with linked server on itself

HI ALL
I got SQL Server 2000 SQL1 and in linked servers i make server SQL2 witch looking at itseft (SQL1)...looks like loopback
I need this for debuging. In real system i got 2 servers
When i start transaction in server SQL01 and do some work with linked server SQL2 i got message
"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].
All options for distributing is on
When i do the same in real system with 2 different servers all do fine
Do this mean that in one server this is not work
Sample
BEGIN TRANSACTION
INSERT INTO SQL1.Base.dbo.Table(Field)
SELECT some
FROM LocalTable
COMMIT TRANSACTIO
Thank U ALL
In Russian
Ð?Ñ?ивеÑ? вÑ?ем.
СобÑ?Ñ?венно еÑ?Ñ?Ñ? Ñ?еÑ?веÑ? SQL 2000 и наÑ?Ñ?Ñ?оеннÑ?й на нем линкед Ñ?еÑ?веÑ?, коÑ?оÑ?Ñ?й Ñ?моÑ?Ñ?еÑ? на Ñ?ебÑ? Ñ?амого, но Ñ?еÑ?ез него Ñ?Ñ?аеÑ?Ñ?Ñ? дÑ?Ñ?гаÑ? база. Ð?Ñ?е Ñ?Ñ?о нÑ?жно длÑ? оÑ?ладки. Ð? Ñ?еалÑ?ной Ñ?иÑ?Ñ?еме Ñ?Ñ?о два Ñ?азнÑ?Ñ? Ñ?еÑ?веÑ?а. Ð?Ñ?е опÑ?ии по вÑ?Ñ?ким кооÑ?динаÑ?оÑ?ам и диÑ?Ñ?Ñ?иб Ñ?Ñ?анзакÑ?иÑ?м Ñ?Ñ?оÑ?Ñ?.
Ð?Ñ?и попÑ?Ñ?ке запÑ?Ñ?ка Ñ?Ñ?анзакÑ?ии вÑ?лезаеÑ? меÑ?ага
"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]."
Ð?Ñ?ли Ñ?Ñ?о два Ñ?азнÑ?Ñ? Ñ?еÑ?вака, Ñ?о вÑ?е Ñ?абоÑ?аеÑ? ок. Чо за на? Ð?Ñ?еÑ?еднаÑ? Ñ?иÑ?а Ð?ила, Ñ?ипа Ñ?ам Ñ? Ñ?абой не можеÑ'
Ð?аÑ?анее Ñ?паÑ?ибо.This is not supported.
This is from http://support.microsoft.com/?id=306215:
Check whether the object on the destination server refers back to the
first server. This is what is known as a loopback situation. This is
not supported, as documented in SQL Server Books Online. For more
information, visit the following Microsoft Web site:
http://msdn.microsoft.com/library/en-us/acdata/ac_8_qd_12_2kvm.asp:
Loopback Linked Servers
Rand
This posting is provided "as is" with no warranties and confers no rights.

No comments:

Post a Comment