I am trying to access data from one SQL Server 2000 server to another SQL Server 2000 server using Linked servers by NT Authentication (Be made using the logins security context) but the query is fetching the local server information.
I have complete and unrestricted access to both the computers in the same domain because my ID was available in windows 2000 Administrators group on both the boxes)

SQL Statement: Select * from TVSServer.TVSDataBase.dbo.TVSTable

Added Linked server by the following procedures
1) 'ERROR 18456: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON”
If I add linked server through enter prise manager'

2) EXEC sp_addlinkedserver @server='TVSServer', @srvproduct='', @provider='SQLOLEDB'
It's fetching data from local server master database

3) EXEC sp_addlinkedserver 'TVSServer', N'SQL Server'
It's fetching data from local server master database

Any comments or suggestions would be very much appreciated.

Thanks in Advance,