SQL Server 2014连接字符串在php中无效[87]


SQL Server 2014 Connection string is not valid [87] in php

从SQL SERVER 2014升级到SQL SERVER 2008。

我已经使用SQL SERVER 2008与PHP。从SQL SERVER 2008升级到SQL SERVER 2014后,它似乎不工作。它显示了以下错误:

[Microsoft][ODBC Driver 11 for SQL Server]SQL Server Network接口:连接字符串无效[87]

[Microsoft][ODBC Driver 11 for SQL Server]Login timeout expired

[Microsoft][ODBC Driver 11 for SQL Server]与网络相关的或在建立连接时发生特定于实例的错误到SQL Server。找不到服务器或无法访问服务器。检查是否实例名是正确的,如果SQL Server配置为允许远程连接。有关更多信息,请参阅SQL Server在线图书。

更改$ in $server

,首先给出UID &PWD then Database

 $server = "servername'instancename"; 
 $connectionInfo = array(  "UID"=>"", "PWD"=>"****", "Database"=>"", );
 $conn = sqlsrv_connect( $server, $connectionInfo ); 
 if ($conn === false)
 die("<pre>".print_r(sqlsrv_errors(), true)); 
 echo "Successfully connected!";