I am having two servers running SQL2000 and SQL2005.
There is a database A,B in SQL2000. Similarly i have the same in A,B in SQL2005.
A,B are name of the database.
I have a linked server pointing from
SQL2005 A database to
SQL2000 B database. Here the scenario is i can able to access database
SQL2000 B database from
Two issues i face i am randomly getting the error
OLE DB provider "SQLNCLI" for linked server "SQL2000" returned message "Communication link failure". Msg 10054, Level 16, State 1, Line 0 TCP Provider: An existing connection was forcibly closed by the remote host. Msg 18456, Level 14, State 1, Line 0 Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
How to resolve the error?.
Also When the user want to access the database located in the same server what must be done?. I mean accessing the database
SQL2005 A database and
SQL2005 A database i.e ignoring the linked server.