douhu2525 2013-10-01 18:18
浏览 29
已采纳

PHP SQL Server访问被拒绝(严重性9)[重复]

This question already has an answer here:

I have an old website that I am moving from an old server to a newer server. I have set up php and verified that it works and I have installed Microsoft SQL Server and migrated the old db and users. I am running php-5.2.13 and windows server 2008 r2

I am having problems connecting to SQL.

<?php
mssql_connect('localhost', 'GeoTracker1', 'GeoTracker1');
?>

Gives me:

( ! ) Warning: mssql_connect() [function.mssql-connect]: Unable to connect: SQL Server is unavailable or does not exist. Access denied. (severity 9) in C:\inetpub\wwwroot\geotracker\mssqlcheck.php on line 2

Call Stack

#

Time

Memory

Function

Location

1 0.0002 102608 {main}( ) ..\mssqlcheck.php:0 2 0.0002 102808 mssql_connect ( ) ..\mssqlcheck.php:2

( ! ) Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: localhost in C:\inetpub\wwwroot\geotracker\mssqlcheck.php on line 2

Call Stack

#

Time

Memory

Function

Location

1 0.0002 102608 {main}( ) ..\mssqlcheck.php:0 2 0.0002 102808 mssql_connect ( ) ..\mssqlcheck.php:2

</div>
  • 写回答

1条回答 默认 最新

  • download92000 2013-10-01 19:14
    关注

    Enable Named Pipes on your new SQL Server.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥50 易语言把MYSQL数据库中的数据添加至组合框
  • ¥20 求数据集和代码#有偿答复
  • ¥15 关于下拉菜单选项关联的问题
  • ¥20 java-OJ-健康体检
  • ¥15 rs485的上拉下拉,不会对a-b<-200mv有影响吗,就是接受时,对判断逻辑0有影响吗
  • ¥15 使用phpstudy在云服务器上搭建个人网站
  • ¥15 应该如何判断含间隙的曲柄摇杆机构,轴与轴承是否发生了碰撞?
  • ¥15 vue3+express部署到nginx
  • ¥20 搭建pt1000三线制高精度测温电路
  • ¥15 使用Jdk8自带的算法,和Jdk11自带的加密结果会一样吗,不一样的话有什么解决方案,Jdk不能升级的情况