Re: Accessing SQL 2K from SQL 7

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 06/26/03 

Date: Thu, 26 Jun 2003 12:21:06 -0400

Try updating MDAC on your SQL 7.0 system. Earlier versions (prior to 2.6 or
2.4, I think) don't understand named instances. If updating MDAC isn't an
option, try creating an alias that includes specifying the port number. 

--
Geoff N. Hiten
Senior Database Administrator
Careerbuilder.com
"Shamim" <shamim.abdul@railamerica.com> wrote in message
news:e9bAog$ODHA.2052@TK2MSFTNGP11.phx.gbl...
> 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
>
>
>
>
>

Relevant Pages

  • Re: Two named instances. Why ?
    ... I agree with Mike & Geoff. ... All my clustered SQL instances have always ... think of to having both instances being named instances and the ...
    (microsoft.public.sqlserver.clustering)
  • Re: Default or named instances??
    ... Come to think of it, a lot of SQL documentation doesn't specify exceptons for clusters where they are clearly warranted, but that is another discussion. ... When it comes to default and named instances on a cluster, you treat the cluster as you would a single system, that is you get a single default instance per cluster, nt per node. ... As for the relationship between a virtual server and an instance, ...
    (microsoft.public.sqlserver.clustering)
  • Re: Multi Instance Cluster Question
    ... You can have one default instance and 15 named instances OR 16 named ... instances on a cluster, but that is just a personal thing. ... Microsoft SQL Server MVP ... > a default instance was named as SQL1. ...
    (microsoft.public.sqlserver.clustering)
  • RE: Error: 25002. The specified buffer size is not valid.
    ... Try moving tempdb to a storage card using SQL CE 2.0 Books Online section ... "Specifying the Location of the Temporary Database .. ...
    (microsoft.public.sqlserver.ce)
  • Windows 2000/2003 cluster problem
    ... I am having a problem failing over in my SQL cluster. ... One node is running Windows 2000 and the other is running Windows 2003. ... Driver][TCP/IP Sockets] Specified SQL server not found. ...
    (microsoft.public.sqlserver.clustering)