freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: MSSQL 2000 with multiple servers on one machine
- From: Brian Bruns <camber AT ais.org>
- To: TDS Development Group <freetds AT franklin.oit.unc.edu>
- Subject: Re: MSSQL 2000 with multiple servers on one machine
- Date: Thu, 18 Oct 2001 20:19:51 -0400 (EDT)
The second SQL Server would have to be running on a second port (other
than port 1433), you need to find out what port that is and specify that
for your server in the interfaces or freetds.conf file.
It should work with either 7.0 or 4.2.
Brian
On Thu, 18 Oct 2001, martin dempsey wrote:
> I'm using freetds-0.51 (compiled with --with-tdsver=4.2) between Linux and
> various Microsoft SQL Servers. Works well with MSSQL 7.0 but I've got a
> small problem on MSSQL 2000. A new feature of MSSQL 2000 allows multiple
> servers on one machine (at one IP address). When connecting to a Windows
> 2000 machine running multiple SQL servers, everything works with the
> connection being made to the "default" server, but there doesn't seem to
> be any way to specify or reach the others (which I need to do). I would
> guess that this feature is a new part of TDS 7.0.
>
> Has anyone else run into this? Any suggestions?
>
-
MSSQL 2000 with multiple servers on one machine,
martin dempsey, 10/18/2001
- <Possible follow-up(s)>
- Re: MSSQL 2000 with multiple servers on one machine, Brian Bruns, 10/18/2001
- Re: MSSQL 2000 with multiple servers on one machine, martin dempsey, 10/19/2001
- Re: MSSQL 2000 with multiple servers on one machine, Brian Bruns, 10/20/2001
Archive powered by MHonArc 2.6.24.