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: "Dann Corbit" <DCorbit AT connx.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] connection to SQL server 2008 express
  • Date: Tue, 23 Feb 2010 12:07:32 -0800

> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org [mailto:freetds-
> bounces AT lists.ibiblio.org] On Behalf Of jklowden AT schemamania.org
> Sent: Tuesday, February 23, 2010 6:48 AM
> To: FreeTDS Development Group
> Subject: Re: [freetds] connection to SQL server 2008 express
>
> 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.

Besides the *machine* being given network access over the port, the
SQL*Server must also be enabled to allow external connections.

Using SQL*Server management studio, right-click on the database cylinder
after establishing a connection to it and choose "Properties".
Then, choose the page "Connections" and click the check box "Allow
remote connections to this server"

Restart the SQL*Server service.





Archive powered by MHonArc 2.6.24.

Top of Page