Skip to Content.
Sympa Menu

freetds - Re: [freetds] Multiple SQL Instances On One Server

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <bill_d_thompson AT ml.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Multiple SQL Instances On One Server
  • Date: Wed, 25 Oct 2006 16:14:27 +0100

well if you have several instances of sql on the same server, they must
listen on different ports.
I usually ask my DBA for the port that a particular server listens on.

You need a seperate entry in freetds.conf for each instance.

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Mark Larsen
Sent: 25 October 2006 16:12
To: FreeTDS Development Group
Subject: Re: [freetds] Multiple SQL Instances On One Server


Thanks for the quick reply.

I think I'm on the correct hunt now. It appears when running multiple
instances of SQL Server, it'll pick ports other than 1433 to run the
non-main instance.

So my question becomes, how do I find the other ports?

On 10/25/06, Thompson, Bill D (London) <bill_d_thompson AT ml.com> wrote:
> and what entries do you have in freetds.conf ?
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
--------------------------------------------------------

If you are not an intended recipient of this e-mail, please notify the
sender, delete it and do not read, act upon, print, disclose, copy, retain or
redistribute it. Click here for important additional terms relating to this
e-mail. http://www.ml.com/email_terms/
--------------------------------------------------------




Archive powered by MHonArc 2.6.24.

Top of Page