Databases
StackOverflow2013
Postsdbo
POWhy won't my server connect to a remote MSSQL server using PHP mssql_connect?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhy won't my server connect to a remote MSSQL server using PHP mssql_connect?
    primarykey
    data
    text
    <p>I've had to move an app we wrote for a client to a new server and a remote connection I was initiating with PHP mssql_connect has ceased to work. I noticed that PHP wasn't compiled with mssql so I asked the server admin to install it. I can verify that it's now installed via PHP info but I now get a consistent "Unable to connect to server" error from mssql_connect.</p> <p>Here's the very simple PHP script I'm running:</p> <pre><code>$myServer = "myserver.com:5000"; $myUser = "myusername"; $myPass = "mypassword"; $dbhandle = mssql_connect($myServer, $myUser, $myPass) or die("Couldn't connect to SQL Server on $myServer. Error: " . mssql_get_last_message()); </code></pre> <p>I've confirmed that the credentials are still correct but for whatever reason it seems that mssql_connect just isn't doing it's thing. I'm wondering if there's something that the admin has forgotton to do having installed the extension and FreeTDS. Any pointers greatly appreciated! :)</p> <p>PROBLEM SOLVED!!!</p> <p>After all that it turned out to be the FreeTDS protocol version number as specified in /usr/local/freetds/etc/freetds.conf, line number 13 had to be uncommented. That was it! :)</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USNathan Pitman
    1. USNathan Pitman
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWhy won't my server connect to a remote MSSQL server using PHP mssql_connect?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POWhy won't my server connect to a remote MSSQL server using PHP mssql_connect?
      1. This table or related slice is empty.
      1. VTUpMod
    1. CODoes it fail immediately or after some timeout? Exact error message? Can you connect from some SQL tools?
      singulars
      1. POWhy won't my server connect to a remote MSSQL server using PHP mssql_connect?
      1. USgbn
    2. COcould be a firewall/routing/dns type issue. can you connect to that host/port (using e.g. telnet) from your php host?
      singulars
      1. POWhy won't my server connect to a remote MSSQL server using PHP mssql_connect?
      1. USMat
    3. COI've set up FreeTDS to log errors and it's reporting "Unexpected EOF from the server"... not sure if that's 'my server' or the remote 'SQL server'. BTW the remote server is SQL Server 2000.
      singulars
      1. POWhy won't my server connect to a remote MSSQL server using PHP mssql_connect?
      1. USNathan Pitman
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload