MSSQL 2000 with multiple servers on one machine
camber at ais.org
Thu Oct 18 20:19:51 EDT 2001
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.
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?
More information about the FreeTDS