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

Lukasz Szybalski <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
Hello,
I'm trying to connected to named instance of sql2008. This is not a
default instance. As I read the :

http://support.microsoft.com/kb/823938

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)'


[SQLServer2008]
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?

Thanks,
Lucas
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.