FreeTDS Development Group

[jklowden AT schemamania.org]

On Tue, Feb 23, 2010 at 08:07:03PM +0530, Mahendra T wrote:
> log.c:190:Starting log file for FreeTDS 0.82
>         on 2010-02-23 19:59:57 with debug flags 0x4fff.
...
> net.c:210:Connecting to IP_Adress port 1433 (TDS version 8.0)
> net.c:264:tds_open_socket: connect(2) returned "Operation now in progress"
> net.c:299:getsockopt(2) reported: Connection refused
> util.c:334:tdserror(58ca0, 570f8, 20009, 150)
...
> I have talked to our network administrator, he says that he has given all 
> the access and opened the required ports.  

Probably it's a server setup issue.  

>From the host running FreeTDS, try:

        $ telnet IP_Adress 1433
        
(where you obviously substitute a real address for "IP_Address").  

The connection will fail, demonstrating you cannot connect to that server on 
that port.  
        
> I could connect to the database instance at 1433 port from the same 
> machine where it is installed. 

SQL server 2008 express by default listens only to 127.0.0.1, not to the 
external network.  You can confirm that by running the above telnet command 
on the SQL Server host.  

If you can telnet locally but not from the FreeTDS host, show those results 
to your network guy.  

--jkl