Problems with using SQL Server2000 and SQL Server 6.5

[dejanv]

HI,
I have a problem using SQL Server 2000 and SQL Server 6.5:
I have SQL Server 2000 as a remote server on SQL Server 6.5 and SQL Server 6.5 as a remote server on SQL Server 2000 and a task wich will insert in a table on SQL Server 2000 some records from a table on SQL Server 6.5 and after that delete those records from 6.5.With openrowset I can tansfer records but I can deleted them.When Irun the task I have a message:
"Login failed- User: Reason: Not associated with a trusted SQL Server connection. [SQLSTATE 28000] (Error 18452). The step failed."

Can anybody helps me?
Thanks in advance.
Dejan <deniv@on.net.mk>

 

[kicho]

This is very good question, but i really don't now the anwser. My colleques had the same problem like you, but they aren't here right now. Tomorow when i see them i will tell them to awnser your question. Sugestion. Why don't you try to use another (third) computer