Showing posts with label named. Show all posts
Showing posts with label named. Show all posts

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.