Jump to content

mkswanson

Members
  • Posts

    10
  • Joined

  • Last visited

Profile Information

  • Gender
    Not Telling

mkswanson's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. 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?
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.