Re: Accessing SQL 2K from SQL 7

nntp
Date: 06/26/03 

Date: Thu, 26 Jun 2003 11:21:02 -0700

Use the client network utility, it's pretty self explanatory.

"Shamim" <shamim.abdul@railamerica.com> wrote in message
news:eC7UztAPDHA.3408@tk2msftngp13.phx.gbl...
> So, I should create an alias in my SQL 7 Box for SQL2K. Is that correct ?
> Pls explain how to create a alias and also specifying port number ??
>
> Thanks
> Sh
>
>
> "Geoff N. Hiten" <SRDBA@Careerbuilder.com> wrote in message
> news:eyjXz7$ODHA.3700@tk2msftngp13.phx.gbl...
> > 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: Scripting creation of server alias
    ... > Does anyone know if there's a way to script creation of a server ... > alias, as you can do using the Client Network Utility? ... Then you can use any programming tool or ...
    (microsoft.public.sqlserver.server)
  • Re: How can I tell what protocols are enabled for the client?
    ... My question is on the Client Network Utility not on the Server Network Utility. ... Based on your reply, even I have only enabled TCP/IP on the General tab of the Client Network Utility, I will still able to connect to an alias which is setup using Named Pipes on the Alias tab of the Client Network Utility. ...
    (microsoft.public.sqlserver.connect)
  • RE: Name of the SQLInstance?
    ... Try using SQL Client Network Utility and creating an alias for your instance. ... The only other way I know of is to rename you machine to 'sqllocal' - that ...
    (microsoft.public.sqlserver.programming)
  • Re: Any suggestions on this error when trying to connect SQL Server 2000?
    ... SQL Server service may be down or hung ... Need to create an Alias using "Client network utility" specifying IP ...
    (microsoft.public.sqlserver.connect)
  • Re: Server alias
    ... "Tom Williams" wrote in message ... > an alias for one of our servers. ... Using the same "Client Network Utility", ... > How can I get rid of it? ...
    (microsoft.public.sqlserver.server)