mssql_connect Woes

[mkswanson]

I'm having problems with a simple mssql_connect to a remote server.

$ngLink = mssql_connect($ngServer, $ngLogin, $ngPassword);

if ( !$ngLink ) {
    die('Connection to database failed!');
}

If I point the server to a local instance of SQL 2008, the connection is successful.

 

If I point the server to a remote instance of SQL 2008, I get a connection failed message.  

 

Both the remote and local PCs are Win2K8 with SQL 2008 standard.

 

I have successfully connected to the remote instance using SQL management studio from my web server, so this does not appear to be a problem with the firewall or blocking based on IP.  I have also successfully connected to the remote SQL instance from my dev box, through management studio and PhpStorm.

 

I have enabled TCP/IP and named pipes in SQL configuration.

 

I have tried capturing the last PHP error, which is a generic connection failed error, as well as the last MSSQL error, which is null since a connection isn't actually happening so MSSQL isn't generating an error.

 

I have reviewed event viewer logs as well as other logs, and not been able to find anything that points me to the right direction.

 

Any suggestions on where I can begin to look to troubleshoot?

[Barand]

mssql_ library is obsolete. Download the sqlsrv lib and documentation from Microsoft for MSSQL Server 2005 onwards

 

http://www.microsoft.com/en-gb/download/details.aspx?id=20098

[DrTrans]

 

 
 
$ngLink = mssql_connect($ngServer, $ngLogin, $ngPassword) or die(mssql_get_last_message()); 
 
print_r($ngLink); 
 

 

 

Let us know what the response is from that print statement.