Accessing SQL 2K from SQL 7

From: Shamim (shamim.abdul_at_railamerica.com)
Date: 06/26/03


Date: Thu, 26 Jun 2003 10:32:28 -0500


We added a new SQL instance of SQL 2K - name XXX\AB

>From SQL 7 server, I did sp_addlinkedserver 'XXX\AB'

when try to access from SQL 7

Select * from [XXX\AB].[dbname].[dbo].[tablename]

"Specified SQL Server not found"

Any thoughts ??

Sh