Skip to Content.
Sympa Menu

freetds - Re: [freetds] connection to SQL server 2008 express

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: jklowden AT schemamania.org
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] connection to SQL server 2008 express
  • Date: Tue, 23 Feb 2010 09:47:50 -0500

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




Archive powered by MHonArc 2.6.24.

Top of Page