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
lmpx.com only provides a reader for public news (NNTP) servers. It is not
affiliated with the servers or forums shown here and is not responsible for
the content of articles, which is written by their respective authors.