[freetds] freetds and mssql 2008 with name instance and dynamic port allocation?

Lukasz Szybalski szybalski at gmail.com
Fri Jul 16 12:41:25 EDT 2010

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?


More information about the FreeTDS mailing list