note 49519 added to ref.mssql

I've spent the last three days wild guessing why I could not connect to MS SQLServer 2000 and so I hope this might help someone else. Microsoft has purposefully closed the 1433 tcp port and others (maybe only to external ips) of the server. You can easily check if this is the case by looking at the Event Monitor. You should see an error produced by MSSQL SERVER/MSDE that basically says what I said. It suggests downloading and installing a security patch to open up the ports (but doesn't even say which update - remember this is Microsoft). Do download Service Pack 3a (SP3a). It does indeed fix the problem. ---- Manual Page -- http://www.php.net/manual/en/ref.mssql.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+49519 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+49519&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+49519&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+49519&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+49519&report=yes&reason=useless Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+49519&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+49519&report=yes Search -- http://master.php.net/manage/user-notes.php