I am having a similiar issue as has been described here except for one thing. The two servers are in different modes and will need to stay that way (2005- mixed; 2000 Windows). When using the "...made using this context..." I also get the "TCP Provider: An existing connection was forcibly...

I am having a similiar issue as has been described here except for one thing. I can access the SQL2000 linked server (security context set to use this specific windows account) while I am logged in as that user. However, if I login as a different user, I then receive the "TCP Provider: An existing...