[freetds] connection to SQL server 2008 express

Mahendra T mahendra.t at tcs.com
Thu Feb 25 08:24:54 EST 2010

I am able to connect to the database by mentioning the port number in the 
like TDSPORT=1433 TDSDUMP=/home/user/freetds.log tsql -S IP_Address -U 
but if it is trying to connect at port 4000 if I don't mention the 
TDSPORT, though the port is set to 1433 in freetds.conf file.
Also I am not able to connect to SQL server from perl, it may be trying to 
connect at port 4000.

Any ideas pls?


"James K. Lowden" <jklowden at freetds.org>
FreeTDS Development Group <freetds at lists.ibiblio.org>
02/25/2010 08:21 AM
Re: [freetds] connection to SQL server 2008 express
Sent by:
freetds-bounces at lists.ibiblio.org

Mahendra T wrote:
> Dynamic ports were enabled in the SQL server configuration, It started 
> working after I disabled them and mentioned 1433 as TCP/IP port.

The current snapshot has (as will the next release) a feature to print
instance information with tsql.  Try 

                 $ tsql -LH hostname

Hrm.  Just noticed if hostname is not valid, you get no port information
(of course) but also no error message.  That's why releases take longer
than snapshots....


FreeTDS mailing list
FreeTDS at lists.ibiblio.org

Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you

More information about the FreeTDS mailing list