[freetds] connection to SQL server 2008 express

jklowden at schemamania.org jklowden at schemamania.org
Tue Feb 23 09:47:50 EST 2010


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



More information about the FreeTDS mailing list