<?php$serverName = "(localhost)"; //数据库服务器地址$uid = "sa"; //数据库用户名$pwd = "lasqadmin5178"; //数据库密码$connectionInfo = array("UID"=>$uid, "PWD"=>$pwd, "Database"=>"test");$conn = sqlsrv_connect( $serverName, $connectionInfo);if( $conn == false){ echo "连接失败!"; die( print_r( sqlsrv_errors(), true));}$query = sqlsrv_query($conn, "SELECT TOP 10 nid,title,content FROM test.dbo.news");while($row = sqlsrv_fetch_array($query)){ echo $row['nid']."-----".$row['title']."<br/>";}?>提示错误信息为:
local 本地,为防止歧义要写作 (local)
sql server 默认是以机器名来识别的服务的(不是域名和ip)