Linked server does not exist or access denied
Posted on 2004-12-01
Windows 2000 pro
SQL Server 2000 sp3a desktop engine
Windows 2000 server std
SQL Server 2000 sp3a server std
The client recently had a hard drive crash and was replaced by a backup-pc - supposed to be 100% identical, but apparently not.
Some tables are being copied from the client to the server, this has stopped working. We get this error message:
Server: Msg 7391, Level 16, State 1, Line 1
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].
Some other times we get a time out error. It seems to be related to (distributed) transactions.
Strangely, the below statement succedes running from the client accessing data on the server:
SELECT TOP 1 * FROM SERVERNAME.TheDB.dbo.tblData
If I run the same query on the server accessing the client server I get this error message:
Server: Msg 17, Level 16, State 1, Line 1
SQL Server does not exist or access denied.
Browsing the linked server tables from the client works, but fails from the server.
Any help is greatly appreciated.