Re: connection to SQL server 2008 express

> -----Original Message-----
> From: [email protected] [mailto:freetds-
> [email protected]] On Behalf Of [email protected]
> 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.