On ServerA (a 2000 SQL Server running sp4) I created a link server ServerB which is a 2005 SQL Server, I have both SQL logins & windows logins set up on both servers with permissions, and "Be made using login's current security context" set. When I run a query from ServerB I receive
"Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "AFDCSQL3". The provider supports the interface, but returns a failure code when it is used."
But when I run a query from ServerA I receive:
"Server: Msg 7314, Level 16, State 1, Line 1
OLE DB provider 'ServerB' does not contain table '"DBName"."Test"'. The table either does not exist or the current user does not have permissions on that table.
OLE DB error trace [Non-interface error: OLE DB provider does not contain the table: ProviderName='ServerB', TableName='"DBName"."Test"'].
Which is not true because I was able to query the database an table "Test" with that login.
What am I missing?