用户的sqlsrv_connect登录失败

Question

我正在尝试使用PHP连接到我的SQL Server数据库。我运行的是WampServer和SQLExpress及其Management Studio。由于某些原因，调用sqlsrv_connect失败。与SQL Server的连接已打开，但用户登录失败。Windows身份验证和SQL Server身份验证都会发生这种情况。我已经在数据库属性的“安全”选项卡下切换到"SQL Server和Windows身份验证模式“。我还检查了" connections“选项卡下是否允许远程连接。我可以通过Management Studio使用SQL Server身份验证进行登录，但不能使用PHP代码。对于我可能做错了什么，任何帮助我都很感激。

<?php
$serverName = "STTM-PC\SQLEXPRESS";
$connectionInfo = array("Database"=>"myDatabase","UID"=>"myUsername","PWD"=>"myPassword");
$conn = sqlsrv_connect($serverName, $connectionInfo);

if ($conn) {
    echo "Connection Established<br/>";
}
else {
    echo "Connection Failed<br/>";
    die( print_r( sqlsrv_errors(), true));
}
?>

打印出以下内容

Connection Failed
Array ( [0] => Array ( [0] => 28000 [SQLSTATE] => 28000 [1] => 18456 [code] => 18456 [2] => [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Login failed for user 'myUsername'. [message] => [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Login failed for user 'myUsername'. ) [1] => Array ( [0] => 42000 [SQLSTATE] => 42000 [1] => 4060 [code] => 4060 [2] => [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot open database "myDatabase" requested by the login. The login failed. [message] => [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot open database "myDatabase" requested by the login. The login failed. ) [2] => Array ( [0] => 28000 [SQLSTATE] => 28000 [1] => 18456 [code] => 18456 [2] => [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Login failed for user 'myUsername'. [message] => [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Login failed for user 'myUsername'. ) [3] => Array ( [0] => 42000 [SQLSTATE] => 42000 [1] => 4060 [code] => 4060 [2] => [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot open database "myDatabase" requested by the login. The login failed. [message] => [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot open database "myDatabase" requested by the login. The login failed. ) )

Answer 1

我找出了问题所在。我从来没有将用户连接到数据库，因此连接没有建立。要修复此问题，我使用Management Studio登录到数据库。我进入了“安全”标签，然后是“登录”标签。我右键单击用户名，然后选择属性。在“用户映射”下，我选择了"myDatabase“将其映射到此帐户。现在，连接已建立。