Re: unable to connect to an instance of SQL server 2005
Tim Uckun <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
> > Can you telnet to port 1433 from a DOS Command Window on IPADDR ? No. That's weird... > > If not, is SQL Server 2005 set up for TCP/IP Connections ? Yes. > > is SQL Server listening on a different port ? not according to the connection manager. Under SQL native connection manager TCP/IP is enabled and it's set to 1433 TCP/IP is also enabled for the instance but the port is dynamic (set to 0) > > Is the firewall on Ubuntu preventing a connection ? No. I can fire up a virtual machine and connect to the database using the SQL server manager on a TCP connection ipaddr\instancename with SQL server authentication. When I connect I go into the options and select TCP as the protocol. It doesn't let me specify the port though so I don't know what port it's using. I presume it's 1433 _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds