[freetds] freetds and mssql 2008 with name instance and dynamic port allocation?
szybalski at gmail.com
Fri Jul 16 14:22:41 EDT 2010
On Fri, Jul 16, 2010 at 11:41 AM, Lukasz Szybalski <szybalski at gmail.com> wrote:
> I'm trying to connected to named instance of sql2008. This is not a
> default instance. As I read the :
> I see that 2008 defaults to dynamic allocated port for its named
> instances, which means port 1433 is no longer active. (telneting port
> 1433 does not respond.)
> How can I setup freetds to use the name instance, will it figure out
> the port number on its own.
> [unixODBC][FreeTDS][SQL Server]Unable to connect: Adaptive Server is
> unavailable or does not exist (20009) (SQLDriverConnectW)'
> Description = Production Server
> Driver = TDS
> Trace = No
> Server = servername
> TDS_Version = 8.0
> Instance = instancename_production
> What are my options here at this point?
> How can I get this to work?
I did confirm that sql is setup on port 0 = dynamic ports. Currently
the instance I'm trying to connect is on port 1079. If server restarts
or this port becomes busy the port # will change.
How is freetds discovering the port location, when using dynamic
ports, and how do I set it up?
More information about the FreeTDS