PHP 5.2.8 unable to connct to server MS SQL server 2008

[landonmkelsey]

OOOPS! posted this in the wrong place the first time

 

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: LANDON\SQLEXPRESSLMKIII in C:\Inetpub\wwwroot\trymssql.php on line 7

 

Fatal error: Maximum execution time of 60 seconds exceeded in C:\Inetpub\wwwroot\trymssql.php on line 7

 

IIS 5.1

XP Prof SP3

PHP 5.2.8

MS SQL server 2008  remote connection turned on

in php.ini      extension=php_mssql.dll

 

simple code:

<?php

// Server in the this format: <computer>\<instance name> or

// <server>,<port> when using a non default port number

$server = "LANDON\SQLEXPRESSLMKIII";

// $server = '(local)\V';

//$server = '.\SQLEXPRESSLMKIII';

$link = mssql_connect($server, "sa", "xoxoxoxo");

 

if(!$link)

{

    die('Something went wrong while connecting to MSSQL');

}

?>

 

I have searched for an existing answer and made some changes. ???

 

I tried this with MS SQL server 2005 and PHP 5.2.6

 

 

 

 

 

[plimpton]

For any new work, especially when working with SQL Server 2k8 you should be using the new sqlsrv driver instead of the community mssql driver. You can find out more here: http://blogs.msdn.com/sqlphp/