PHP连接sqlserver2008，怎么连接指定ip地址上的数据库

知之洲 2014-07-21 01:33:20

$serverName = "(local)"; //数据库服务器地址

$uid = "sa"; //数据库用户名

$pwd = "password123"; //数据库密码

$connectionInfo = array("UID"=>$uid, "PWD"=>$pwd, "Database"=>"test");

$conn = sqlsrv_connect( $serverName, $connectionInfo);

if( $conn == false)

{

    echo "连接失败！";

    die( print_r( sqlsrv_errors(), true));

}

if($conn){

echo "连接成功";

}

连接成功了，但是怎么把local改成127.0.0.1这样的

...全文

205 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

terell 2015-07-30

打赏
举报

楼主你是怎么解决的呀？那两位大哥是……

知之洲 2014-07-21

打赏
举报

谢谢两位大哥

小在在 2014-07-21

打赏
举报

服务器实例这样写： $serverName = "127.0.01\sqlexpress, 1542"；1542可以不写，默认是1433；

小在在 2014-07-21

打赏
举报

1、运行 SQL Server 配置管理器：SQL Server Configuration Manager，打开协议 Protocols 允许命名管道 "named pipes" 和 "tcp/ip" 2、右键点击 "tcp/ip"，打开属性 Properties 标签 "IP addresses" 3、在 TCP 动态端口 "TCP Dynamic Ports" 填入 1433 4、重启 SQL Server

知之洲 2014-07-21

打赏
举报

header("Content-type: text/html; charset=gb2312");
$serverName = "127.0.0.1"; //数据库服务器地址
$uid = "sa"; //数据库用户名
$pwd = "password123"; //数据库密码
$connectionInfo = array("UID"=>$uid, "PWD"=>$pwd, "Database"=>"test");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
//$conn= new PDO("sqlsrv:Server=127.0.0.1;Database=test","sa","yyyy1111") or die ("PDO Connection faild.");
if( $conn == false)
{
    echo "连接失败！";
    die( print_r( sqlsrv_errors(), true));
}
if($conn){
echo "连接成功";
}

结果：连接失败！Array ( [0] => Array ( [0] => 08001 [SQLSTATE] => 08001 [1] => 5 [code] => 5 [2] => [Microsoft][SQL Server Native Client 11.0]Named Pipes Provider: Could not open a connection to SQL Server [5]. [message] => [Microsoft][SQL Server Native Client 11.0]Named Pipes Provider: Could not open a connection to SQL Server [5]. ) [1] => Array ( [0] => HYT00 [SQLSTATE] => HYT00 [1] => 0 [code] => 0 [2] => [Microsoft][SQL Server Native Client 11.0]Login timeout expired [message] => [Microsoft][SQL Server Native Client 11.0]Login timeout expired ) [2] => Array ( [0] => 08001 [SQLSTATE] => 08001 [1] => 5 [code] => 5 [2] => [Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. [message] => [Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. ) )

知之洲 2014-07-21

打赏
举报

header("Content-type: text/html; charset=gb2312");
$serverName = "127.0.0.1/MSSQLSERVER"; //数据库服务器地址
$uid = "sa"; //数据库用户名
$pwd = "password123"; //数据库密码
$connectionInfo = array("UID"=>$uid, "PWD"=>$pwd, "Database"=>"test");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
//$conn= new PDO("sqlsrv:Server=127.0.0.1;Database=test","sa","yyyy1111") or die ("PDO Connection faild.");
if( $conn == false)
{
    echo "连接失败！";
    die( print_r( sqlsrv_errors(), true));
}
if($conn){
echo "连接成功";
}

结果：连接失败！Array ( [0] => Array ( [0] => 08001 [SQLSTATE] => 08001 [1] => 67 [code] => 67 [2] => [Microsoft][SQL Server Native Client 11.0]Named Pipes Provider: Could not open a connection to SQL Server [67]. [message] => [Microsoft][SQL Server Native Client 11.0]Named Pipes Provider: Could not open a connection to SQL Server [67]. ) [1] => Array ( [0] => HYT00 [SQLSTATE] => HYT00 [1] => 0 [code] => 0 [2] => [Microsoft][SQL Server Native Client 11.0]Login timeout expired [message] => [Microsoft][SQL Server Native Client 11.0]Login timeout expired ) [2] => Array ( [0] => 08001 [SQLSTATE] => 08001 [1] => 67 [code] => 67 [2] => [Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. [message] => [Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. ) )