Skip to Content.
Sympa Menu

freetds - Re: MSSQL 2000 with multiple servers on one machine

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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?
>





Archive powered by MHonArc 2.6.24.

Top of Page