note 49519 deleted from ref.mssql by cmb
| From: | cmb@php.net | Date: | Sun, 18 Aug 2019 08:36:01 +0000 |
| Subject: | note 49519 deleted from ref.mssql by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-211919@lists.php.net to get a copy of this message | ||
Note Submitter: marcel at fluidleb dot com
----
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.