Friday, March 30, 2012

linking named instance of sql2000 from sql7

Is it possible to link named instance of sql2000 from
sql7. I created similar link on a sql2000 server which
works fine. However, when I create the same link on a sql
7 it does not work. It will not give any error. In the
enterprise manager It seem to be trying to access the
tables but then come back with nothing."Obaid" <anonymous@.discussions.microsoft.com> wrote:
> Is it possible to link named instance of sql2000 from
> sql7.
--
SQL 7.0 knows nothing about named instances. This feature is not available.
--
Eric Cárdenas
SQL Server support|||It is possible to trick it by creating an alias on the sql7 machine and
forcing sql2k instance to use a static port for listening.
Vikram
"Obaid" <anonymous@.discussions.microsoft.com> wrote in message
news:c5ce01c3b9e0$b3722140$a601280a@.phx.gbl...
> Is it possible to link named instance of sql2000 from
> sql7. I created similar link on a sql2000 server which
> works fine. However, when I create the same link on a sql
> 7 it does not work. It will not give any error. In the
> enterprise manager It seem to be trying to access the
> tables but then come back with nothing.

No comments:

Post a Comment