Table Does Not Exist Linked Server 2000 to 2005
Posted on 2014-03-23
I have two servers, a SQL 2000 and a SQL 2005 and need to have them be linked to each other. 2005 is linked successfully to 2000 and can query from various databases on it. 2000 is linked successfully but can only query data from Master database, not other databases. If I try and query from another database I get the following:
Server: Msg 7314, Level 16, State 1, Line 1
OLE DB provider 'APPSQL1' does not contain table '"IERP86US"."dbo"."Item"'. 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='APPSQL1', TableName='"IERP86US"."dbo"."Item"'].
Both servers are using sa logon and have same settings.