我正在尝试从php连接到mssql数据库。我已经为此安装了驱动程序。
现在我遇到了以下错误:
域阵列(域阵列( => 28000 SQLSTATE => 28000 1 => 18456 code => 18456 2 => MicrosoftSQL ServerLogin failed for user‘domain\User.消息=> MicrosoftSQL ServerLogin对于用户'domain\ user‘失败。)1 =>阵列(用户‘域\用户’的=> 28000 SQLSTATE => 28000 1 => 18456代码=> 18456 2 => MicrosoftSQL ServerLogin失败。消息=> MicrosoftSQL ServerLogin对于用户'domain\ user‘失败。))
我是不是漏掉了什么?
编辑:我的连接字符串:
$serverName = "server, port";
$connectionInfo = array( "Database"=>"my_database");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn == false)
{
echo "Unable to connect.<br />";
die( print_r( sqlsrv_errors(), true));
}
编辑2:
包含user和pw的代码示例
$serverName = "server, port"; //serverName\instanceName
$connectionInfo = array( "Database"=>"my_database", "UID"=>"domain\user", "PWD"=>"my_pw");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn ) {
echo "Connection OK.<br />";
}else{
echo "Unable to connect.<br />";
die( print_r( sqlsrv_errors(), true));
}
https://stackoverflow.com/questions/55262754
复制相似问题