I have SQL 7 And SQL 2000.
I would like to setup a trigger in SQL7 that updates a table in SQL2000.
So i created a linked Server in SQL7 pointing to SQL2000.
When i was logged into the SQL server it worked perfectly.
However I logged off and now using the Enterprise manager of another machine to do the work.
When i atempt the connection i get:
Not associated with a trusted SQL Server connection.
I created an Admin user for the Linked Server on SQL2000.
Still no lock.