从PHP/FreeBSD远程连接到SQL Server标准版 [英] Remote connect to SQL Server Standard Edition from PHP/FreeBSD

问题描述

无法从我们的FreeBSD服务器之一连接到我们公司的MSSQL服务器.

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

MSSQL服务器上没有运行防火墙，并且我已经打开了BSD-FW上的默认端口

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

对此有何想法?

在Windows Server 2003上运行的MSSQL服务器的详细信息

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

推荐答案

我将MSSQL更新为Service Pack 4，现在可以通过指定端口远程登录到服务器.并使用pdo_dblib从PHP连接到服务器

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

这篇关于从PHP/FreeBSD远程连接到SQL Server标准版的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！