问题:

Unable to connect to our company MSSQL server from one of our FreeBSD servers.

# telnet 192.168.1.51 1433
Trying 192.168.1.51...
telnet: connect to address 192.168.1.51: Connection refused
telnet: Unable to connect to remote host

No firewall running on the MSSQL server, and i have opened the default port on the BSD-FW

00210 allow tcp from any to any dst-port 1433 in
00215 allow tcp from any to any dst-port 1433 out

Any ideas on this?

The specifics of the MSSQL server running on a Windows Server 2003

回答1:

Test whether you can connect from another non-local machine. If not TCP connections may not be enabled for SQL Server. Here are instructions for enabling TCP/IP Connections with SQL Server 2000

回答2:

I updated it MSSQL to Service Pack 4, and i'm now able to telnet to the server on the specified port. And also connect to the server from PHP with pdo_dblib