[PHP]无法连接mssql服务器 [英] [PHP] Can't connect mssql server

问题描述

<?php
//
ini_set('display_errors','On');
error_reporting(E_ALL | E_STRICT);

$serverName = "WIN-TKQHRGCY678\SQLEXPRESS"; //serverName\instanceName


$connectionInfo = array( "Database"=>"dbTest", "UID"=>"WIN-TKQHRGCY678\MyAccount", "PWD"=>"123456z");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if( $conn ) {
     echo "Connection established.<br />";
}else{
     echo "Connection could not be established.<br />";
     die( print_r( sqlsrv_errors(), true));
}

?>

i收到此消息

无法建立连接。

i got this message
Connection could not be established.

Array ( [0] => Array ( [0] => 28000 [SQLSTATE] => 28000 [1] => 18456 [code] => 18456 [2] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'WIN-TKQHRGCY678\MyAccount'. [message] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'WIN-TKQHRGCY678\MyAccount'. ) [1] => Array ( [0] => 28000 [SQLSTATE] => 28000 [1] => 18456 [code] => 18456 [2] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'WIN-TKQHRGCY678\MyAccount'. [message] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'WIN-TKQHRGCY678\MyAccount'. ) )

推荐答案

serverName = WIN-TKQHRGCY678\SQLEXPRESS; // serverName \ _instanceName

serverName = "WIN-TKQHRGCY678\SQLEXPRESS"; //serverName\instanceName

connectionInfo = array（ 数据库 => dbTest， UID => WIN-TKQHRGCY678 \ MyAccount， PWD => 123456z）;

connectionInfo = array( "Database"=>"dbTest", "UID"=>"WIN-TKQHRGCY678\MyAccount", "PWD"=>"123456z");

conn = sqlsrv_connect（

conn = sqlsrv_connect(

这篇关于[PHP]无法连接mssql服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！