I have problem regarding linked server between one SQL Server 2000 Standard Ed. SP4 (default instance) and SQL Server 2005 Developer Ed SP1 (named instance on same machine).
I created it with:
- Name: EXAMPLE
- option Other data source: Microsoft OLE DB Provider for SQL Server
- Product name: '.'
- Data source: ServerName\InstanceName
- security: remote login with password
- Server Options: dataAccess, RPC, RPC Out, User Remote Collation - checked.
But, when try to perform 'select * from EXAMPLE.DBName.dbo.TableName I've got messagge:
"Server: Msg 14, Level 16, State 1, Line 1
I've got the same linked server in cluster environment where both servers are developer edition (first is SQL 2000 and the second is SQL 2005). And it works.
What could be a problems ?