[freetds] connection to SQL server 2008 express
DCorbit at connx.com
Tue Feb 23 15:07:32 EST 2010
> -----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
> > 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
> > 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
> 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.
More information about the FreeTDS